Firebase querying grandchildren without knowing the keys

Question

I have a data structure like this:

UserOrders
   ---- UserId1
          ----OrderId1
                 ----...
                 ----status: pending
                 ----...
          ----OrderId2
                 ----...
                 ----status: fulfilled
                 ----...
   ----UserId2
          ----OrderId3
                 ----...
                 ----status: pending
                 ----...

From UserOrders, I want to get all the orders that are pending.

firebaseAdmin.database().ref("UserOrders").orderByChild("...??...").equalTo("pending");

Is this possible in Firebase, without making any changes to the data structure?

Thanks.

score 2 · Accepted Answer · answered Feb 14 '19 at 15:12

No, you can't query across multiple levels of unknown keys. You can only query using field values that are all children of the same immediate parent. So, you could find all the orders for a particular user, but you can't find all the orders for all the users that match.

Firebase querying grandchildren without knowing the keys

1 Answers1