Compare Firestore Array to another Firestore Array with whereArrayContains

Question

I wanted to compare an array value with another array in firestore The code below works as "ingredients" is an array in firestore, and "sugar" is what the ingredients compare to but i want to make "ingredients" compare to my String[] array value 1 by 1 For example if : String[] a = {"sugar","b","c"} , then this should be true String[] b = {"salt","pepper"}, then this will false. I have commented in my code for a more clearer need.

Putting Arrays.asList(test) didnt work. Any solution?

   List<String> ingreList;
   String[] ingredientLists;
   String[] test = {"sugar","b"};


private void checkTesting() {
        postRef.whereArrayContains("ingredients", "sugar" /*PUTTING STRING[] HERE TO COMPARE OR ARRAYLIST STRING IS ALSO FINE TOO (I HAVE BOTH) */)
                .get()
                .addOnSuccessListener(new OnSuccessListener<QuerySnapshot>() {
                    @Override
                    public void onSuccess(QuerySnapshot queryDocumentSnapshots) {
                        postLists3.clear();
                        for(QueryDocumentSnapshot documentSnapshot: queryDocumentSnapshots){
                            Post post = documentSnapshot.toObject(Post.class);
                                postLists3.add(post);
                        }
                        postAdapter.notifyDataSetChanged();
                        progressBar.setVisibility(View.GONE);
                    }
                });
    }

Dharmaraj · Accepted Answer · 2021-09-21 10:33:26Z

1

You would have to use whereArrayContainsAny as shown below if you want to pass any array instead of a string:

postRef.whereArrayContainsAny("ingredients", Arrays.asList("sugar"))

However do note that this will fetch document where the ingredients field contains at least 1 item in the list passed in whereArrayContainsAny. For example, if the ingredients field in a document has ["sugar", "milk", "water"] and you query with Arrays.asList("sugar"), the document will be returned in query result.

If you want to fetch documents where all the ingredients are included then you might have to store ingredients as a map:

ingredients: {
  sugar: true,
  water: true
}

Then you can add multiple .whereEqualTo("ingredients.[NAME]", true); and query the required documents.

answered Sep 21, 2021 at 10:33

Dharmaraj

51.3k8 gold badges67 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Compare Firestore Array to another Firestore Array with whereArrayContains

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related