Fetching multiple documents at the same time

Issue

I'm trying to fetch multiple documents but I'm unable to do it. I wanted to fetch multiple documents containing my search criteria.

Here's what I tried.

final FirebaseFirestore db = FirebaseFirestore.instance;
QuerySnapshot<Map<String, dynamic>> querySnapshot = await db
              .collection('MyCollection')
              .where('FldName', 'in', ['123', '345', '111']).get();

Error on the syntax which is pointing in the 'in':

Too many positional arguments: 1 expected, but 3 found.

Here's what my firebase looks like.

Solution

You need to use whereIn like this:

.where('FldName', whereIn: ['123', '345', '111']).get();

Not, in as a String.

Answered By - Huthaifa Muayyad