Android Firebase Query to find more than one value in different keys

Question

I want to create a search function like facebook that help all user to search other user by more than one value under Users list in my application.

I read the example from here https://firebase.google.com/docs/database/admin/retrieve-data

here is my firebase :

I able to search the the user from firebase by "fullname" . here is my application : my applicantion

usersRef = FirebaseDatabase.getInstance().getReference().child("Users");

    Query searchAllQuery = usersRef
            .orderByChild("fullname")
            .startAt(searchBoxInput.toUpperCase())
            .endAt(searchBoxInput.toLowerCase() + "\uf8ff" )

edited this is the code for my recycle view

    FirebaseRecyclerOptions<SearchUserList> options = 
             new FirebaseRecyclerOptions.Builder<SearchUserList>()
            .setQuery(searchAllQuery, SearchUserList.class).build();

I expected the output can be search by more that one value for example :

.orderByChild("fullname")
.orderByChild("username")
.orderByChild("country")

when I key in USA , all user with value "usa" will show out.
when I search for username "wei" ,users with value "wei" will show in the list

@ConstantinBeer yes, when we search for Fullname / nickname , user with that value will show out. From the example above , i can search TTT / sp to find out this user from my firebase — qing, Aug 24 '19 at 13:37
Firebase Database queries can only order/filter on a single property. In many cases it is possible to combine the values you want to filter on into a single (synthetic) property. So for example you could have a property `"country_username_fulname": "usa_sp_TT"` For a longer example of this and other approaches, see my answer here: http://stackoverflow.com/questions/26700924/query-based-on-multiple-where-clauses-in-firebase — Frank van Puffelen, Aug 24 '19 at 14:00

Yash · Accepted Answer · 2019-08-24T12:33:03.977

3

Firebase doesn't support ordering by multiple queries.

Queries can only order by one key at a time. Calling orderByChild() multiple times on the same query throws an error.

Try ordering by a simple query an then filter the data, sample:

Query searchAllQuery = usersRef
            .orderByChild("fullname")
            .startAt(searchBoxInput.toUpperCase())
            .endAt(searchBoxInput.toLowerCase() + "\uf8ff" )

searchAllQuery.addValueEventListener(new ValueEventListener() {
    @Override
    public void onDataChange(DataSnapshot dataSnapshot) {
        for (DataSnapshot snapshot : dataSnapshot.getChildren()) {
        // filter your data here by username and country
        User user = dataSnapshot.getValue(User.class);
        if (user.getUsername().contains('wei')  || user.getCoutnry().contains('usa')) {
            // add the user to your list maybe?
        }
        }
    }

    @Override
    public void onCancelled(FirebaseError firebaseError) {

    }
});

edited Aug 24 '19 at 12:33

answered Aug 24 '19 at 12:26

Yash

3,438
2
17
33

So can I assume that this is the best way to create a search function that can search for multiple values in my "user"? – qing Aug 24 '19 at 13:30
so i can just add the query code you provide on top of this--> FirebaseRecyclerOptions – qing Aug 24 '19 at 13:46
you can view my edited line above – qing Aug 24 '19 at 13:46
Yes and then in your adapter, filter out the values – Yash Aug 24 '19 at 13:50
If you don't want the query to run if field is empty, just put a check for empty field. – Yash Aug 24 '19 at 13:56

Android Firebase Query to find more than one value in different keys

1 Answers1