Expand my Community achievements bar.

SOLVED

Selecting sub- expressions in a query

Avatar

Level 4

Hi All,

 

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

 

Rut7_1-1692088455554.png

 

Could anyone please explain the above.

 

Thank you,

Rutuja Kelkar

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@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-... for the reverse example as suggested by @ParthaSarathy 

View solution in original post

2 Replies

Avatar

Correct answer by
Employee Advisor

@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-... for the reverse example as suggested by @ParthaSarathy 

Avatar

Community Advisor

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

 

LakshmiPravallika_1-1692171222615.png

 

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-a...

 

LakshmiPravallika_2-1692171428206.png

 

Regards,

Pravallika.