What's new in Customer Journeys?

Connect and learn more! ×
Using hierarchy in a runtime filter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using hierarchy in a runtime filter

Accepted answer
edited Sep 27, 2019 12:21PM in Reporting & Analytics for B2C Service 5 comments


Creating an if(expr & expr,1,0) filter using prod_hierarchy.id


Hi all

Just wondering if anyone knows the answer to this one
I tried a few things but I'm unable to succeed.

If we take the following working example

if(incidents.c$incident_type.id = 151 & incidents.prod_id.id = 186, 1,0)

And if we want to have this in a filter as to exclude certain incidents where both the custom field and product id have a certain value we would have to use the hierarchy as prod_id is not available in filters.

So basically this (non working example)

if(incidents.c$incident_type.id = 151 & incidents.prod_hierarchy = 186, 1,0)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!