javascript - Firebase - IN query not working in where clause getting blank array as result

Question

When I try to filter my data with IN query it's not showing me the result I am getting a blank array in result I have tried the same thing in the firebase console. I am not getting result there as well.

My data is messages/01fjubNOf8oYODitr1h6 In this path, I have keys - name, message, participants

{
  name: "Pawan arora",
  message: "test",
  participants: ["33", "127"]
},
{
  name: "TEST NAME",
  message: "not working",
  participants: ["114", "127"]
}
{
  name: "TEST DATA",
  message: "new",
  participants: ["114", "33"]
}

I tried in the query to filter data my query is

.collection("messages").where("participants", "in", ["33", "127"])

Here I should get the first object as a result

Firebase database image

Answer 1

You need to use array-contains-any operator instead when filtering arrays.

Try this:

.collection("messages").where("participants", "array-contains-any", ["33", "127"])

For details check this blogpost.