Making a query for firestore with multiple where clause

Question

I am working on a flutter application which I m using firestore but now for searching, I have a query. The query will be like this

SELECT * 
FROM User 
WHERE age IS BETWEEN 16 TO 40 
  AND gender IS male 
  AND isSearching IS true

I have written the code for this query in flutter is like this

CollectionReference collection=FirebaseFirestore.instance.collection("Posts").doc(myMood).collection("Comments");

    Query  _searching=collection.where('isSearching',isEqualTo: true);
    Query _gender=_searching.where('gender',isEqualTo: preferredGender);
    Query _ageless=_gender.where('age',isEqualTo: values.start.round());
   Query _agemore=_ageless.where('age',isLessThanOrEqualTo: values.end.round() );

_agemore.get().then((querySnapshots) {
  print(_ageless.toString());
      if(querySnapshots.docs.length == 0)
      {
        print('data is empty');
      }
      else
      {
          print('data found');
      }

  });

I have manually set the data in firestore but I always give output data is empty. What will be the best way to write down a query for above statement

Jo Eder · Accepted Answer · 2020-11-14 09:17:56Z

1

You might have to create an extra key for this. Usually when you execute the query, android studio will throw an error and provide you with a link to create an index for you project.

answered Nov 14, 2020 at 9:17

Jo Eder

3381 gold badge3 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ALMAPA SA DE CV Over a year ago

I have created an index for it

marc_s · Accepted Answer · 2020-12-24 14:15:36Z

0

Could you try this

    CollectionReference collection=FirebaseFirestore.instance.collection("Posts").doc(myMood).collection("Comments");
    Query  _searching=collection.where('isSearching',isEqualTo: true);
    Query _gender=_searching.where('gender',isEqualTo: preferredGender);
    Query _agemore=_gender.where('age',isLessThanOrEqualTo: values.end.round() );
    
    _agemore.get().then((querySnapshots) {
    print(_ageless.toString());
    if(querySnapshots.docs.length == 0)
    {
        print('data is empty');
    }
    else
    {
        print('data found');
    
    }
    
});    
});

edited Dec 24, 2020 at 14:15

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Nov 14, 2020 at 12:31

Hayrettin Çetintaş

761 gold badge1 silver badge11 bronze badges

Collectives™ on Stack Overflow

Making a query for firestore with multiple where clause

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related