Hello, I wanted to create a JQL query to output a ...
# questions
r
Hello, I wanted to create a JQL query to output a collection of users who did not perform a certain event with a certain event property during a certain time. How do you query for “did not” + output a list of users not events This is what I have so far. “this outputs a list of events not users”
Copy code
function main() {
  return join(
      Events({
        from_date: "2022-01-01",
        to_date: "2022-11-01"
      }),
      People())
  .filter(function(tuple) {
    return tuple.event && tuple.user &&
        tuple.event.name == "Action: Place Order Success" &&
        tuple.event.properties.payment_type == 'cc'
  });
}