Re-base (firebase) query for nested children and sorting

Question

I know that firebase recommends that you denormalize the structure of your database ... but what if you did not listen correctly ...

Example:

• of users

• • user1
• • • Foo
• • • • Baz
• • • • bar
• • • chat rooms
• • • • (huge json)
• • user2
• • • Foo
• • • • Baz
• • • • bar
• • • chat rooms
• • • • (huge json)

foo and chats are my way to denormalize data within each user.

Is it possible to query users/*/foo and sort it by bar ?

Answer 1

No. You cannot complete a query regarding the sibling property.