How to query an array of objects contains a field value firebase angular?

Question

I have the following document:

"players" : [ 
  {
    "id" : userid,
    "name" : "dissident"
  }, 
  {
    "teamId" : teamId,
    "name" : "ink"
  }
]

This is what I tried, but it is not working

this.afs.collection('matches', ref => ref.where('players', 'array-contains', {teamId: teamId}))

can you please elaborate more on it what is your expected output? — Mridul
– Mridul, Commented Jan 8, 2020 at 6:45
@Mridul Im trying to get this document only if the players array contains the given team id — user12268835
– user12268835, Commented Jan 8, 2020 at 6:50
Are you referring JSON as document? and you want to return the whole object if teamid matches with given team id? — Mridul
– Mridul, Commented Jan 8, 2020 at 6:54
You may be interested by this answer: stackoverflow.com/questions/54081799/… which explains that it is not possible, with array-contains, to query for a specific property of an object stored in an array — Renaud Tarnec
– Renaud Tarnec, Commented Jan 8, 2020 at 8:53

Doug Stevenson · Accepted Answer · 2020-01-08 07:00:42Z

1

Your error is this:

FirebaseError: Function Query.where() called with invalid data. Unsupported field value: undefined (found in field teamId)

This means you passed an invalid value of undefined for teamId in the query, which is invalid. You should debug your code and figure out why teamId is undefined, then fix that.

answered Jan 8, 2020 at 7:00

Doug Stevenson

321k37 gold badges458 silver badges474 bronze badges

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

2 Comments

user12268835 Over a year ago

I even tried hardcoding the id to get the data it is not working

Doug Stevenson Over a year ago

That sounds like a different problem than the one you first posted. Maybe ask another question if it's different by nature?

Alex Mamo · Accepted Answer · 2020-01-08 10:09:02Z

1

To solve this, please change the following line of code:

this.afs.collection('matches', ref => ref.where('players', 'array-contains', {teamId: teamId}))

to

this.afs.collection('matches', ref => ref.where('players', 'array-contains', {teamId: teamId, name : 'ink'}))

As you can see, this is actually possible only if you query for the entire object. But be aware, as Doug Stevenson mentioned in his answer if you pass an invalid value of undefined for teamId or for name, you'll always get the error that you are talking about.

answered Jan 8, 2020 at 10:09

Alex Mamo

139k18 gold badges171 silver badges202 bronze badges

Collectives™ on Stack Overflow

How to query an array of objects contains a field value firebase angular?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related