Composite index not working for query with where about geoflutterfire HOT 6 CLOSED

It works when you specify position.geohash ascending as one of your index fields

from geoflutterfire.

I think the trick is to pass a CollectionReference to geo.collection. Calling .where() on a CollectionRef returns a Query object, so if you call .reference() on the Query object, it should work. At least, it did for me.

You could do something like:

stream = radius.switchMap((rad) {
        var collectionReference = Firestore.instance.collection('users').where('atEvent',isEqualTo: true);
        return geo.collection(collectionRef: collectionReference.reference()).within(
            center: userLoc, radius: rad, field: 'position');
      });

Another person had a similar question:

#47 (comment)

from geoflutterfire.

Did you ever find a solution to this problem? Same issue for weeks but never could figure it out so I did an inefficient workaround of using the queried data and trimming it with if statements such as, in your example, after you listen for the stream and get the list of document data:

if (document.data['atEvent']) { listOfDocs.add(document); }

from geoflutterfire.

No i haven't, this needs to be addressed since most apps will need an additional query...

from geoflutterfire.

@stevenspiel I am going to have to try that out sometime.

from geoflutterfire.

It works when you specify position.geohash ascending as one of your index fields

Thanks a lot worked

from geoflutterfire.