Solved

Is it possible to use custom events in JQL?

  • 31 July 2020
  • 2 replies
  • 85 views

Badge
  • New Participant
  • 0 replies

Hello,
I have 2 questions regarding JQL:

  1. Is it possible to use custom events created in Insights in a JQL query?
  2. Is it possible to filter an event with 2 conditions using && or something like that?
    I tried the query below but it returned events with value1 OR value2 instead of AND.
function main() {  return Events({    from_date: '2020-07-24',    to_date:   '2020-07-31',    event_selectors: [       {event: 'Screen View', selector: 'properties["propertyName1"] == "value1"' && 'properties["propertyName2"] == "value2"', label: 'Custom Event'}})

Thank you in advance!!

icon

Best answer by Emmett 31 July 2020, 23:43

  1. Sadly no, JQL works at the raw data, so any UI based entity, custom events, cohorts, custom properties would need to be recreated in the query.
  2.  Simply put yes and its just and:
    'properties["propertyName1"] == "value1" and properties["propertyName2"] == "value2"'
    Built as listed in this doc: 

https://help.mixpanel.com/hc/en-us/articles/115005061286-Building-Segmentation-Expressions

View original

2 replies

  1. Sadly no, JQL works at the raw data, so any UI based entity, custom events, cohorts, custom properties would need to be recreated in the query.
  2.  Simply put yes and its just and:
    'properties["propertyName1"] == "value1" and properties["propertyName2"] == "value2"'
    Built as listed in this doc: 

https://help.mixpanel.com/hc/en-us/articles/115005061286-Building-Segmentation-Expressions

Excellent explanation Thanks to Emmett

Reply