Firestore: Multiple where clauses

Question

    let query = db.collectionGroup('volumes')
    query = query.where('days', 'array-contains', day)
    query = query.where('start_time', '<', time)
    query = query.where('end_time', '>', time)
    snapshot = await query.get().catch(e => console.log(e))
    snapshot.forEach(doc => {
        console.log(doc.data())
    })

returns:

code: 2, details: '', metadata: Metadata { internalRepr: Map { 'content-type' => [Array] }, options: {} }

If I use only one "where" clauses its works just fine.

For me its not working... Firestore: Multiple conditional where clauses

Did you try instructions mentioned in firebase.google.com/docs/firestore/security/… — Codex
– Codex, Commented Sep 7, 2020 at 11:59
can you show the complete logs from firebase --debug emulators:start including the failed transaction? Also is there anything in firestore-debug.log? — Samuel Romero
– Samuel Romero, Commented Sep 7, 2020 at 17:27

Doug Stevenson · Accepted Answer · 2020-09-07 19:14:22Z

1

The query you're trying to perform is not supported by Firestore. You can't have multiple range queries on different fields. Be sure to read of the documentation on query limitations. Specifically:

Queries can only perform range filters (>, <, etc) on a single field. Queries with range filters on multiple fields are not supported.

answered Sep 7, 2020 at 19:14

Doug Stevenson

320k37 gold badges458 silver badges474 bronze badges

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

Collectives™ on Stack Overflow

Firestore: Multiple where clauses

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related