Firestore index URL not generated for arrayContains in collection group?

Question

snapshot1 uses and single collection and snapshot2 uses a collection group

final snapshot1 = await FirebaseFirestore.instance
    .collection('users')
    .doc('115309562732908784445')
    .collection('user_activities')
    .where('userGroupIDs', arrayContains: 'IIPwobuR3YLrOoLH3TeS')
    .get();
final snapshot2 = await FirebaseFirestore.instance
    .collectionGroup('user_activities')
    .where('userGroupIDs', arrayContains: 'IIPwobuR3YLrOoLH3TeS')
    .get();

snapshot1 generates fine by snapshot2 throws

Exception has occurred.
FirebaseException ([cloud_firestore/failed-precondition] Operation was rejected because the system is 
not in a state required for the operation's execution. If performing a query, ensure it has been 
indexed via the Firebase console.)

but I'm not getting the auto-generate URL. The above message overlapped the VSCode editor window. I didn't see any URL messages in the Debug Console nor the Firestore logs.

Is there something wrong with my query? Or maybe sometimes you have to create them manually?

Can you add your edit as an answer?, this can help others

Jan Hernandez
– Jan Hernandez

2021-01-27 16:42:21 +00:00
Commented Jan 27, 2021 at 16:42 — Jan Hernandez
– Jan Hernandez, Commented Jan 27, 2021 at 16:42

buttonsrtoys · Accepted Answer · 2021-01-27 18:26:19Z

1

I built the Index manually and it worked fine. Was simple to do following Todd's blog. As a test, I deleted a couple of my existing Indices and the debugger properly gave me a URL to rebuild. Not sure why it didn't like this one.

answered Jan 27, 2021 at 18:26

buttonsrtoys

2,7894 gold badges42 silver badges64 bronze badges

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

Collectives™ on Stack Overflow

Firestore index URL not generated for arrayContains in collection group?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related