swipe•8mo ago

Firebase complex queries (OR, AND)

The current firestore collection query allows for filters, but doesn't seem to support OR queries. Is that true? I'd love to be able to do something like:


val db = Firebase.firestore
val usersRef = db.collection("users") 
val queryByAdminOrAge= usersRef.where(Filter.or(
        Filter.equalTo("admin", true),
        Filter.greaterThanOrEqualTo("age", 18)    
))


val db = Firebase.firestore
val usersRef = db.collection("users") 
val queryByAdminOrAge= usersRef.where(Filter.and(
    Filter.equalTo("technology", "Firebase"),
    Filter.or(
        Filter.equalTo("admin", true),
        Filter.greaterThanOrEqualTo("age", 18)
    )    
))

Solution:

Hi @swipe, You can try with this workflow template. It uses the custom filter logic to support OR query, thanks to @Luis. 🎉

message_12.txt

Jump to solution

3 Replies

Gaurav Chadha•8mo ago

Should be possible, we'll take a look. Thanks for mentioning along with example snippet.

swipe•5mo ago

@Gaurav Chadha would appreciate any suggestions

Solution

Gaurav Chadha•5mo ago

Hi @swipe, You can try with this workflow template. It uses the custom filter logic to support OR query, thanks to @Luis. 🎉

message_12.txt