Firestore - Filter by two array-contains queries in two different fields

Question

I am trying to filter two different fields in my Firestore using array-contains, I have seen older posts saying you can't use two array-contains in the same query but was wondering if this is still the case, or is there another way I could achieve the same outcome?

I did think, maybe do two separate queries, but both fields are in the same collection, so not sure if this would be the optimum way.

function getAllUserPlumb(){

      var engineercounty = $('#engcounty').val();

    console.log(engineercounty);

    var docRef = db.collection("users");
    docRef.where("trade", "array-contains", "Plumbing").where("engpostcode", "array-contains", engineercounty).get().then(function(querySnapshot) {
    querySnapshot.forEach(function(doc) {
         // console.log(doc.data());
      html = createEngineerRow(doc.data(),doc.id);

       // $('#user_id').find('tbody').append(html);

    });

  });}

Maybe if I used '!=' in combination with array-contains?

docRef.where("trade", '!=', ['Drainage', 'Gas & Heating', 'Glazing', 'Locksmiths', 'Pest Control', 'Electrical']).where("engpostcode", "array-contains", engineercounty)

LyonsTheWay2Gold · Accepted Answer · 2021-03-31 09:37:03Z

1

I have a possible solution.

function getAllUserPlumb(){

      var engineercounty = $('#engcounty').val();

    // console.log(engineercounty);

    var docRef = db.collection("users");
    docRef.where("engpostcode", "array-contains", engineercounty).get().then(function(querySnapshot) {


      querySnapshot.forEach(function(doc) {


        if(doc.data().trade.includes('Plumbing') ){
  
           
         // console.log(doc.data());
          html = createEngineerRow(doc.data(),doc.id);

       // $('#user_id').find('tbody').append(html);

   
        }




 

  });});}

edited Mar 31, 2021 at 9:37

answered Mar 31, 2021 at 7:30

LyonsTheWay2Gold

3731 silver badge13 bronze badges

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

Collectives™ on Stack Overflow

Firestore - Filter by two array-contains queries in two different fields

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related