Firestore retrieve docs with where clause object in object

Question

I want to get all the jobs that Grade value New/Near New inside the job. job->container->grade Equal to New/Near New.

What programming language are you using? Please respond with @AlexMamo — Alex Mamo
– Alex Mamo, Commented Aug 24, 2021 at 7:42

Frank van Puffelen · Accepted Answer · 2021-08-24 14:21:33Z

1

To get all jobs with a grade value of New/Near New, you can use a query like this:

// Create a reference to the jobs collection
var collectionRef = db.collection("jobs");

// Create a query against the collection.
var query = collectionRef.where("container.grade", "==", "New/Near New");

And then you execute the query as also shown in the docs.

answered Aug 24, 2021 at 14:21

Frank van Puffelen

603k85 gold badges896 silver badges869 bronze badges

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

1 Comment

Jeewantha Over a year ago

You saved me @Frank . I also want to know about how to set multiple filters inside the where clause programmatically or dynamically. I am using react js i want to set multiple where clauses depend on user input. eg: 1st case User want to filter Status and Created time same time, 2nd case User want to filter status, Created time, Grade same time. How to set Filters depend on user selection>

Collectives™ on Stack Overflow

Firestore retrieve docs with where clause object in object

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related