Is there any way to use OR query with Firestore RecyclerAdapter?

Question

I have a recyclerview using Firestore Recyclerview Adapter, Now I want to show the list by using OR query. For example I want to show the list which are either in "Pending" state OR "Assigned" state using query. I know firestore doesn't have OR query inbuilt but I want to achieve this anyhow. Any alrernative solution.

I have stored 4 state in firestore db : Pending, Assigned, Accepted and Completed. Only want to show pending or assigned

Below is my code:

    Query query = requestVehiclesCollectionReference
            .whereEqualTo("clientId", id)
     // show list which are in Pending state or Assigned state
            .whereEqualTo("status", "Pending")
            .orderBy("createdAt", Query.Direction.DESCENDING);


    FirestoreRecyclerOptions<Item> options = new 
    FirestoreRecyclerOptions.Builder<Item>()
            .setQuery(query, Item.class)
            .build();

Just use two queries one for pending and one for assigned. Then you have to validate which one of them you want to use outside your query. — Constantin Beer, Sep 07 '19 at 08:43
How to set two query inside FirestoreRecyclerOptions, since it support only one query ? — Fortray, Sep 07 '19 at 08:45
@Fortray You could use a if-statement for example. Just try to find out how it fits best in your use case. — Constantin Beer, Sep 07 '19 at 08:55

score 0 · Answer 1 · answered Sep 07 '19 at 15:01

Firestore doesn't support queries with OR conditions. See:

The common workaround is to use multiple queries (one for each condition) and merge the results in your application code.

FirebaseUI's adapters show data from a single query or collection. They have no option to show the results from multiple queries/collections.

From this combination it follows that you can't show data from an OR condition with a single FirebaseUI adapter. You will have to create you own adapter for this, although you can certainly use the (open-source) FirebaseUI adapters for inspiration.

Is there any way to use OR query with Firestore RecyclerAdapter?

1 Answers1