Combining Array-contains with == in Firebase

Question

I have documents where I have a map field of teacher containing uid and username and in that same document I have a array field of students that contains the student id's now I want to query documents based on both field how can I merge the code below

var teacherRef = db.collection('classes')
                   .where("teacher.id", "==", localStorage.getItem("user"))

var studentRef = db.collection('classes')
                   .where("students", "array-contains", localStorage.getItem("user"))

I want to create a logical OR operation with this two where queries — Aritra Basu
– Aritra Basu, Commented May 31, 2020 at 16:06
I found this Medium article that might be helpful to you on this concept. — Artemis Georgakopoulou
– Artemis Georgakopoulou, Commented Jun 3, 2020 at 9:31

zken · Accepted Answer · 2020-05-31 08:41:17Z

1

You can combine multiple where in a single query :

var classTeacherRef = db.collection('classes')
    .where("teacher.id", "==", localStorage.getItem("user"))
    .where("students", "array-contains", localStorage.getItem("user");

Keep in mind that Firebase will ask you to create index for both properties to make it work.

answered May 31, 2020 at 8:41

zken

1,0369 silver badges29 bronze badges

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

1 Comment

Aritra Basu Over a year ago

This will not solve my problem because it is a logical AND operation with two queries but I want to create a logical OR operation between this two where query.

Collectives™ on Stack Overflow

Combining Array-contains with == in Firebase

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related