Question
Filtering reports embedded in JO outreaches by Data type other than 'ID'
I have run into a problem when attempting to filter an embedded report inside of a Journey Orchestrator Outreach. I am wanting to filter by a 'String' field, but have found that the only data types that I can filter by is of type 'ID'.
I have tried using the rules engine to write my string value to a GSID field, but this breaks the rule due to data type mismatches. An example of what I am trying to filter would be by country, if Country = USA, where USA is what I bring in by field mapping, and Country is a field within the embedded report (currently cannot filter like this). Is there any way to manipulate a string value into an ID value in order to filter the embedded report?
-Steven
I have tried using the rules engine to write my string value to a GSID field, but this breaks the rule due to data type mismatches. An example of what I am trying to filter would be by country, if Country = USA, where USA is what I bring in by field mapping, and Country is a field within the embedded report (currently cannot filter like this). Is there any way to manipulate a string value into an ID value in order to filter the embedded report?
-Steven
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.