Order Firebase Cloud Firestore query by multiple fields

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.

Hey jeffbowen, you are correct that this currently isn't possible with the base Firestore query setup in GUI mode. We do have a raw query option that is in beta, and you would have greater control over the query parameters. You can read more about it here.

Oooh. Nice. I'll check it out. Thanks @joeBumbaca!