Firestore Query with .where conditions

Question

I am using the following query:

Query postsQuery = FirebaseFirestore.instance.collection('posts')
  .where('postType', isNotEqualTo: 'Discussion') //post types - Simple, featured, discussion
  .orderBy('createdAt', descending: true)
  .where('group', isEqualTo: groupName) //india, usa, pakistan
  .limit(perPage);

The query runs if i remove this :

.where('postType', isNotEqualTo: 'Discussion')

Anyone knows what i am doing wring here?

Also, if its' a compound query, then the vscode logs show the link in order to build index for the query but the logs aren't showing anything. — Fiaz Ali
– Fiaz Ali, Commented Oct 6, 2021 at 20:07

Renaud Tarnec · Accepted Answer · 2021-10-06 20:10:47Z

2

It seems that you haven't declare the Firestore index corresponding to your query.

As explained in the doc:

Cloud Firestore ensures query performance by requiring an index for every query. The indexes required for the most basic queries are automatically created for you. As you use and test your app, Cloud Firestore generates error messages that help you create additional indexes your app requires.

...

If you attempt a compound query with a range clause that doesn't map to an existing index, you receive an error. The error message includes a direct link to create the missing index in the Firebase console.

So, add a catch() block to the code used to execute the query and you will get the link in the error message. Note: This link is to be opened (once) via a web browser, not via the Flutter app.

edited Oct 6, 2021 at 20:10

answered Oct 6, 2021 at 20:09

Renaud Tarnec

83.4k10 gold badges99 silver badges130 bronze badges

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

6 Comments

Fiaz Ali Over a year ago

Will do in a moment. Let me get back to you.

Fiaz Ali Over a year ago

I added try-catch block with showDialog widget in case query returns an error. Still its giving the error and not showing the link in the logs to build index for this compound query. i have build indexes for the queries and there is always a link in the logs but in this case logs are not displaying anything.

Fiaz Ali Over a year ago

"Note: This link is to be opened (once) via a web browser, not via the Flutter app." I know about this and had build indexes multiple times in the past.

Renaud Tarnec Over a year ago

Can you show a screenshot of your indexes, taken from the console?

Fiaz Ali Over a year ago

Also, thanks for the help as you suggested the method to identify the problem.

|

Collectives™ on Stack Overflow

Firestore Query with .where conditions

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related