Calling variable in Query’s ‘Is included in’ operator  inside  a Report | Community
Skip to main content
November 11, 2024
Solved

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

  • November 11, 2024
  • 1 reply
  • 565 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

Hi @satyampa1 

 

Try $noescaping([vars/Country])

 

Thanks,

David

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
November 11, 2024

Hi @satyampa1 

 

Try $noescaping([vars/Country])

 

Thanks,

David

David Kangni