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

frankybboy · Accepted Answer · 2017-11-07 23:15:26Z

31

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 7, 2017 at 23:15

frankybboy

5491 gold badge5 silver badges12 bronze badges

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

2 Comments

continuousqa Over a year ago

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?

Rory Over a year ago

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

BorisD · Accepted Answer · 2019-10-02 19:49:28Z

7

Here is the answer :

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

More info Here

answered Oct 2, 2019 at 19:49

BorisD

1,86422 silver badges27 bronze badges

1 Comment

MarketerInCoderClothes Over a year ago

Not the OP here, but thank you for sharing this. I think FieldPath is useful and yet underused.

Rafael Santos · Accepted Answer · 2017-11-07 23:16:50Z

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 7, 2017 at 23:16

answered Nov 7, 2017 at 22:53

Rafael Santos

338 bronze badges

1 Comment

frankybboy Over a year ago

doesn't seem to do the trick, the query still returns 0 result

Mahdi Magdi · Accepted Answer · 2018-07-02 23:49:16Z

-4

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 2, 2018 at 23:49

answered Jul 2, 2018 at 23:41

Mahdi Magdi

111 bronze badge

Collectives™ on Stack Overflow

Firestore query using an object element as parameter

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related