Firebase query for multiple where condition

Question

I need equivalent query of

SELECT PlayerName FROM GameScores WHERE Department = 'HR' OR Department = 'IT' OR Department = 'Marketing'

In Firebase for android , I don't want multiple call, just one request and get all data that match with where clause key. How I can do it?

@Martin: the question you link is about filtering on multiple properties, while this one wants to filter on multiple values of a single property. — Frank van Puffelen
– Frank van Puffelen, Commented Nov 22, 2017 at 14:37

Frank van Puffelen · Accepted Answer · 2017-11-22 14:43:01Z

3

The only way to filter a property on multiple values in Firebase is if those values are in a range. For example, you could get all items matching your values with:

ref.child("GameScores")
   .orderByChild("Department")
   .startAt("HR")
   .endAt("Marketing")

The problem with this is that it also matches scores from other departments whose name is between HR and Marketing, such as

There is no way in either the Firebase Realtime Database or Cloud Firestore to pass multiple separate values into a query. You will have to execute a separate query for each value and merge them client-side.

Also see:

firebase equivalent to sql where in ()

answered Nov 22, 2017 at 14:43

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

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

1 Comment

Prince Kumar Over a year ago

Thanks Frank I tried your solution and i have restructure my db

Collectives™ on Stack Overflow

Firebase query for multiple where condition

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related