Firestore query object with dynamic where and order clause

Question

i am dynamically generating where clause and it is working fine . referring to this solution : Firestore query Cursors Generating Dynamic Queries

        function buildQueryNew(collectionRef ,  whereClauses , _limit) {
           let q = query(
             collectionRef,
             ...whereClauses.map((clause) =>
             where(clause[0], '==', clause[1])),
               limit(_limit)
             )
           return q;
         }

But when i am adding the orderBy Clause it is not working .

        function buildQueryNew(collectionRef ,  whereClauses  , sortField,sortOrder , _limit) {
               let q = query(
                 collectionRef,
                 ...whereClauses.map((clause) =>
                 where(clause[0], '==', clause[1])),
                 orderBy(sortField,sortOrder),
                   limit(_limit)
                 )
               return q;
             }

Also i have seen if i remove the whereClause map then orderBy is working fine, its like they both are not working together , anything wrong i am doing ?

whereClause Sample: [ [ "name", "himanshu" ] ]

Screenshot below for database :

What are the values of `sortField` and `sortOrder` when you call `buildQueryNew`? — Alex Mamo, Apr 12 '23 at 09:44
Please edit your question and add your database structure as a screenshot. What value does `clause[0]` hold? — Alex Mamo, Apr 12 '23 at 10:27
Did you define the necessary index for the query? https://firebase.google.com/docs/firestore/query-data/indexing — Frank van Puffelen, Apr 12 '23 at 15:07
But orderBy is working without where clause , anyways let me try that also . — Mohit H, Apr 13 '23 at 05:28
Same result , wither where clause is working or the orderby clause . Let me try more . Thanks for your efforts , incase i found some solution i will paste here . — Mohit H, Apr 13 '23 at 08:22

Firestore query object with dynamic where and order clause

0 Answers0