Expand my Community achievements bar.

SOLVED

Calling variable in Query’s ‘Is included in’ operator  inside  a Report

Avatar

Level 1

Hello everyone,

 

I am trying to use "is included in" in the Query activity of a Report where the values are coming from a Textbox of a report through a variable.

 

EX: Country is included in $([vars/Country])

 

Ex of values: X,Y,Z

 

 

Instead of considering it as separate value the condition is considering it as a single string and returning no value.

 

 

There is already a similar post but is for the query activity of a Workflow.

 

Solved: Calling instance variable in Query’s ‘Is included ... - Adobe Experience League Community - 641694

 

Where the accepted answer to modify the query in Advance section of the Query activity

 

But In my case For Report, Query activity doesn't have Advance Tab.

 

Please provide your valuable suggestions.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @SatyamPa1 

 

Try $noescaping([vars/Country])

 

Thanks,

David



David Kangni

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi @SatyamPa1 

 

Try $noescaping([vars/Country])

 

Thanks,

David



David Kangni