Managing multiple where conditions with Firestore

Question

I am fetching results from my collection using 3 search fields.

If this.tag is empty I don't want this .where("tagarray", "array-contains", this.tag) to work, similarly if this.dt is empty .where('lastActivityDate', '>=', this.dt) should not work. Same for this.leadstage.

How do I manage this condition ?

  loadItems(){
    this.firestore.collection('leads' , ref => ref 
.where("tagarray", "array-contains", this.tag) 
.where('lastActivityDate', '>=', this.dt) 
.where("leadstage" , "==" , this.leadstage)

Edit 1

My entire code of this function

loadItems(){
this.firestore.collection('leads' , ref => ref 
.where("tagarray", "array-contains", "tag1") //tag success
.where('lastActivityDate', '>=', '07-APR-2020') //date success
.where("leadstage" , "==" , 'Prospect') // leadstage success, this is case sensitive
.limit(5)
).snapshotChanges()
.subscribe(response => {
if(!response.length){
  console.log("no data available");
  return false;
}
this.tableData = [];
for(let item of response){
  var data = Object.assign(item.payload.doc.data(), {id : item.payload.doc.id})
  this.tableData.push(data);

...

Edit 2

Screenshot of error

Edit 3

Current code

    this.firestore.collection('leads' , (ref) => {
      let query = ref;
      if (this.tag) {
        query = query.where("tagarray", "array-contains", this.tag) 
      }
      if (this.dt) {
        query = query.where('lastActivityDate', '>=', this.dt) 
      }
      if (this.leadstage) {
        query = query.where("leadstage" , "==" , this.leadstage) 
      }
      return query; 
    }
    )
    .limit(5)
.snapshotChanges()
.subscribe(response => {
if(!response.length){
  console.log("no data available");
  return false;
}
...

Errors:

Type 'Query' is missing the following properties from type 'CollectionReference': id, parent, path, doc, addts(2739)

Property 'limit' does not exist on type 'AngularFirestoreCollection'.ts(2339)

my code is different than that one, someone is helping me, please dont close the question — user2828442, Apr 05 '20 at 19:24
You may edit your question, to add an **Edit 3** at the end, to explain why it is not a duplicate. Be detailed, and then ping @DougStevenson to say you have updated the question. — halfer, Apr 05 '20 at 21:13
The answer given in that thread is using `get()` method , i have already achieved it with that but i am using `('leads' , ref => ref ....snapshotChanges()` and as per docs things are not working, @frank is also trying to help me, but till now it is not resolved. — user2828442, Apr 06 '20 at 04:49

Frank van Puffelen · Answer 1 · 2020-04-05T21:08:21.300

1

You can build your query with multiple condition checks, like this:

this.firestore.collection('leads' , (ref) => {
  let query = ref;
  if (this.tag) {
    query = query.where("tagarray", "array-contains", this.tag) 
  }
  if (this.dt) {
    query = query.where('lastActivityDate', '>=', this.dt) 
  }
  if (this.leadstage) {
    query = query.where("leadstage" , "==" , this.leadstage) 
  }
  return query; 
})...

edited Apr 05 '20 at 21:08

answered Apr 05 '20 at 19:06

Frank van Puffelen

565,676
79
828
807

`loadItems(){ let query = ref; if (this.tag) {....` cannot find name ref – user2828442 Apr 05 '20 at 19:16
i have edited question, copied entire function if you can have a look and guide accordingly – user2828442 Apr 05 '20 at 19:20
The `ref` in my answer is the same as what you use in your question in `ref => ref .where...`. – Frank van Puffelen Apr 05 '20 at 20:26
in my code its `('leads' , ref => ref)` , and when i type what you guided, it says cannot find name `ref`, i have copied my entire function, if you can have a look and update your answer, will be very helpful – user2828442 Apr 05 '20 at 20:29
I have updated my question, added screenshot , see `Edit:: 2` – user2828442 Apr 05 '20 at 20:33
Ah, I think I might have misunderstood the AngularFire API before. See the latest update to my answer, which puts the query building into the callback. – Frank van Puffelen Apr 05 '20 at 21:09
Still not resolved, i have updated the code in `Edit::3` error coming for `query` and `limit` – user2828442 Apr 06 '20 at 04:52

Managing multiple where conditions with Firestore

Edit 1

Edit 2

Edit 3

1 Answers1