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
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.