Selecting sub- expressions in a query | Community
Skip to main content
R
Rut7
Level 3
August 15, 2023
Solved

Selecting sub- expressions in a query

  • August 15, 2023
  • 2 replies
  • 872 views

Hi All,

 

I wanted to learn how to selected - a sub- query as shown in below image with an "exist such as" option pop:

 

 

Could anyone please explain the above.

 

Thank you,

Rutuja Kelkar

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 akshaaga

@rut7 ,

If you have condition like delivery log exists such as And delivery's intenalName equlas to 'abcd', then who had received delivery 'abcd' would get targeted.

As an example-> If the condition is just 'broadLogRcp exist' is the condition, then recipients who are in broadLogRcp schema would be targeted in the Query.

You can refer to https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/do-not-exist-such-as/td-p/592812 for the reverse example as suggested by @parthasarathy 

2 replies

akshaaga
Adobe Employee
akshaagaAdobe EmployeeAccepted solution
Adobe Employee
August 15, 2023

@rut7 ,

If you have condition like delivery log exists such as And delivery's intenalName equlas to 'abcd', then who had received delivery 'abcd' would get targeted.

As an example-> If the condition is just 'broadLogRcp exist' is the condition, then recipients who are in broadLogRcp schema would be targeted in the Query.

You can refer to https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/do-not-exist-such-as/td-p/592812 for the reverse example as suggested by @parthasarathy 

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
August 16, 2023

Hi @rut7 ,

 

If you select the condition "exists such as" , then the recipients in that Targeting Schema will be selected in the query.

Example: 

 

If your Targeting dimension is "Recipients (nms:recipient), and if you apply filtering condition using "exists such as" operator by selecting the schema as  "Recipient Delivery Logs (nms:broadLogRcp)" , then the recipients in "Recipient Delivery Logs (nms:broadLogRcp)" will get Targeted ie, the recipient should be present in the Delivery Logs Schema and also in the nms:recipient Schema

 

 

Please refer to the below documentation link for this operator, and alternative solution instead of using this operator and efficient way to use it.

 

https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/targeting-activities/query.html?lang=en

 

 

Regards,

Pravallika.

 

Terms & ConditionsAccessibility statement

Loading footer...