Hi there, I can’t figure out how to use the $ne filter correctly in the data api. Here is what I’m trying to query. Everything works up until I add the “$ne” part. Can you help? Thank you!
{
"dataSource":"Cluster0",
"database":"v1",
"collection":"pipedriveDeals",
"filter":{
"reasonLost":{
"$ne":"Existing Customer"
}
},
"inquiryDate":{
"$lt":{
"$date":"2022-04-15T00:00:00Z"
},
"$gt":{
"$date":"2022-04-01T00:00:00Z"
}
},
"sourceFirst":"Google Paid"
}