Selecting sub- expressions in a query

Question

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 Answer

@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 · Answer

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.

Sign up

Login with SSO

Login to the community

Login with SSO