How can I build a query to retrieve ordered list without using orderBy twice?

Question

For example if I take a simple SQL query:

Select user WHERE name = jack ORDER BY date_added ASC

The firebase Query to retreive all users with name jack will look like:

myRef.orderByChild("name").equalTo("jack")

but if I add

myRef.orderByChild("name").equalTo("jack").orderByChild("date_added")

I will get

java.lang.IllegalArgumentException: You can't combine multiple orderBy calls!

so how can I order by ASC and DESC after using orderBy and equalto?

I don't know how firebase works, but in plain sql you can order by two columns just putting then together in the order clause, but separated by comma: http://stackoverflow.com/questions/2051162/sql-multiple-column-ordering — jonathanrz, Nov 26 '16 at 19:14

score 4 · Answer 1 · edited May 23 '17 at 12:34

4

you can't use orderByChild more than one time. i ran into this problem and i ended up by using orderByChild once and filter the data on my client . you can refer to this answer , it will help you

edited May 23 '17 at 12:34

Community

1
1

answered Nov 26 '16 at 23:11

Mohamed Nageh

1,963
1
19
27

how can i achieve result? – Aditya Vyas-Lakhan May 02 '17 at 09:05
use orderByChild and then filter the rest of the data on your client side – Mohamed Nageh May 02 '17 at 11:39

How can I build a query to retrieve ordered list without using orderBy twice?

1 Answers1