Solved

JQL Filter By Cohort

  • 16 September 2019
  • 1 reply
  • 167 views

Userlevel 4
Badge

Goal: I'd like to filter my JQL query in my platform app request by passing in a cohort.

Issue: JQL request fails. Unsure where and how to add filter

MP.api.jql(function main() {
   return join(Events({
      from_date: "2019-01-01",
      to_date: "2019-09-01",
   }), People({
      user_selectors: [{
         selector: 'filter_by_cohort: \'{"id":"123456"}\''
      }]
   }), {
      type: "inner",
      selectors: [{
         event: 'Event',
         selector: 'properties["prop"] > 0'
      }]
   })
})

icon

Best answer by evanmoss 17 September 2019, 02:25

Hi mpcomm1,


Unfortunately the JQL API has no way of accessing cohorts data. You'll need to add logic to your query to filter in the same way.


View original

1 reply

Badge +1

Hi mpcomm1,


Unfortunately the JQL API has no way of accessing cohorts data. You'll need to add logic to your query to filter in the same way.


Reply