Question

JQL filter by and , or on list of values not working. Returning all the values in or.

  • 21 December 2021
  • 0 replies
  • 9 views

function main() {     return Events({"from_date": "2021-01-01", "to_date": "2021-12-20"}).filter(function(event) {return event.properties["App Name"] == "PATIENT" && event.properties["Network Type"] == "Wifi" && (event.properties["Phone"] == "2138007068" || event.properties["Phone"] == "8544444733" || event.properties["Phone"] == "2022476613")})     .groupBy(['properties.Phone'], mixpanel.reducer.null())     .map(function(event) {         return {             "Phone" : event.key[0]         };      }); }

The query is returning all the values in the list of Phone values even though they don’t have any Events corresponding to them. Any help is appreciated. Thanks.


0 replies

Be the first to reply!

Reply