Firestore query using an object element as parameter

Question

i'm using Firestore as my database in a project and i have a table that i need to do a query inside an object

{
   foo: "data",
   bar: "data",
   exObject: {
      dataToQuery: "value"
   }
}

here is an example of a structure where i want to do a query inside the object a query that would look like this:

dbRef.collection("Table").where("exObject.dataToQuery", "==", "value")

but this is not working.

Is there a way to query in Firestore using an object's inner value as parameter? If not, is there a way to achieve something that would give the same result?

Example of a Firestore Structure

score 30 · Accepted Answer · answered Nov 07 '17 at 23:15

30

dbRef.collection("Table").where("exObject.dataToQuery", "==", "value")

this syntax i first posted is indeed the good syntax and started working eventually. I'd class the reason of my problem as a typo that i must have corrected trying a lot of different things

answered Nov 07 '17 at 23:15

frankybboy

529
5
12

I realize this is a year old, but I'm working with the same .where method on firestore. I just don't know how to access the data returned. the Object returned shows the right id under the QuerySnapshot, but I don't see the actual object itself. How did you access the object it returns? – continuousqa Oct 15 '18 at 19:08
`let theResults = dbRef.collection("Table").where("exObject.dataToQuery", "==", "value")` – Rory Aug 09 '19 at 13:11

score 6 · Answer 2 · answered Oct 02 '19 at 19:49

6

Here is the answer :

.where(new firestore.FieldPath('exObject' , 'dataToQuery'), '==', "value"))

More info Here

answered Oct 02 '19 at 19:49

BorisD

1,611
17
22

Not the OP here, but thank you for sharing this. I think FieldPath is useful and yet underused. – MarketerInCoderClothes Jan 19 '21 at 11:30

Rafael Santos · Answer 3 · 2017-11-07T23:16:50.803

0

Try ( change from 'Table' to 'TEST' )

xptoCollection : AngularFirestoreCollection<any>;

  constructor(private afs: AngularFirestore) { }

      this.xptoCollection = this.afs.collection('TEST', ref => {
        return ref.where('exObject.{dataToQuery}', '==', 'value');
      });

edited Nov 07 '17 at 23:16

answered Nov 07 '17 at 22:53

Rafael Santos

33
8

doesn't seem to do the trick, the query still returns 0 result – frankybboy Nov 07 '17 at 23:06

Mahdi Magdi · Answer 4 · 2018-07-02T23:49:16.127

-5

for some reason to work , u need to leave space between object_name and .property_name

'exObject .dataToQuery'

instead of

 'exObject.dataToQuery'

leave space and it worked for me

edited Jul 02 '18 at 23:49

answered Jul 02 '18 at 23:41

Mahdi Magdi

1
1

Firestore query using an object element as parameter

4 Answers4

Linked

Related