Firestore query on multiple fields

Question

I have a collection

created_at: 28 January 2023 at 14:41:04 UTC+5
id: "e44a154f-b0cb-4ef6-bc27-af37f178b46c"
message: "1 Orders has been uploaded successfully"
read: true
writer: "16315bd844e95c5926a92bda9"

I want to write a query for getting all the records form the notifications collections which are orderBy created_at and where writer === "16315bd844e95c5926a92bda9"

I have tried this query

const ref = collection(db, "notifications")
query(
  ref, 
  where("writer", "==", '16315bd844e95c5926a92bda9'), 
  orderBy('created_at', 'desc'), 
  limit(5)
)

but it does not showing any data.

But when i delete the orderBy part its filtering the collection

The query in your question needs a composite index, which you need to add manually. If you (catch errors and) check the log output, you'll find an error message about a missing index, which included a link to the Firebase console where you can create the index with a single click. — Frank van Puffelen
– Frank van Puffelen, Commented Jan 31, 2023 at 14:23

Frank van Puffelen · Accepted Answer · 2023-01-31 14:26:08Z

1

The query in your question needs a composite index, which (unlike single-field indexes) you need to add yourself.

If you (catch errors and) check the log output, you'll find an error message about a missing index, which included a link to the Firebase console where you can create the index with a single click.

answered Jan 31, 2023 at 14:26

Frank van Puffelen

603k85 gold badges896 silver badges869 bronze badges

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

1 Comment

Noman M. Khan Over a year ago

I happened to create index at firebase where I set the created_at desc, but when i am querying by asc its giving me error. Is there a way to query by both order i.e. ace and desc?

Collectives™ on Stack Overflow

Firestore query on multiple fields

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related