Firestore Ignore empty string value in query

Question

I have a firebase database of "users" with bunch of fields. I also have a filter that executes a query on those fields and returns the filtered users. The problem is the query can get an object where the location value is an empty string, if the value is "" I want ignore that .where line of code but execute the other ones. I've tried converting the value to undefined and null but undefined throws an error and null displays no users.

exports.filterUsers = (req, res) => {    
 db.collection("users")
.where("gender", "==", req.body.gender)
.where("age", "<=", req.body.maxAge)
.where("age", ">=", req.body.minAge)
.where("location", "==", req.body.location)
.get()

You can simply choose not to add a where clause if you don't need it, as illustrated in the duplicate. — Doug Stevenson, Aug 12 '20 at 15:09

score 3 · Accepted Answer · answered Aug 12 '20 at 15:07

Since the where() method returns a Query, you can do as follows:

let query = db.collection("users")
.where("gender", "==", req.body.gender)
.where("age", "<=", req.body.maxAge)
.where("age", ">=", req.body.minAge);

if (req.body.location === "") {
   query = query.where("location", "==", req.body.location);
}

query.get()...

Firestore Ignore empty string value in query

1 Answers1