Selecting sub- expressions in a query

[Rut7]

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

[akshaaga · Accepted solution]

@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 

[LakshmiPravallika]

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

Regards,

Pravallika.