Currently it does not seem like it's possible to create a Firestore query with multiple orderBy
clauses on Retool.
I need to be able to do this in order to paginate a query. The primary field I'm ordering by has many documents with the same value so in order to use a cursor (startAt
), I need to order by a second field to help disambiguate my desired startAt
point.
Here's an example of that scenario from the Firestore docs.
Along with this, you'd need to be able to specify the direction of the orderBy
sort for each orderBy
clause. Check out this doc to see that in action.