Query | Community
Skip to main content
ASNeelima
ASNeelima
Level 2
May 24, 2022
Solved

Query

  • May 24, 2022
  • 1 reply
  • 772 views

What are Resource and Target options in " Properties " of Query ? what they do ?

 

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 costa_n11

Hi @asneelima 

Resource is the entity where the selection criteria will apply. In SQL mode, this corresponds to the entity set in the FROM clause

Targeting is the entity that will be returned, in SAL mode, this corresponds to the entity in the SELECT clause.

By default Targeting is the Resource entity, however if you have 0-1 or 1-1 relationship on the Resource entity, you can decide to return the entity from the relation.

For instance, if you query Delivery Logs and want to return profile, the Resource entity will be Delivery Logs while the Targeting entity will be Profile (Delivery Log has a 1-1 relationship to Profile). In the former, the count will be the number of delivery logs fitting the criteria while in the later the count will be the number of Profile fitting the criteria on the Delivery Logs.

See also the documentation: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/targeting-activities/query.html?lang=en#targeting-dimensions-and-resources 

You can do a quick test to convince yourself and use Preview in the Query activity to see the differences,

Hope this helps,

Thanks

Denis

 

1 reply

C
Adobe Employee
costa_n11Adobe EmployeeAccepted solution
Adobe Employee
May 24, 2022

Hi @asneelima 

Resource is the entity where the selection criteria will apply. In SQL mode, this corresponds to the entity set in the FROM clause

Targeting is the entity that will be returned, in SAL mode, this corresponds to the entity in the SELECT clause.

By default Targeting is the Resource entity, however if you have 0-1 or 1-1 relationship on the Resource entity, you can decide to return the entity from the relation.

For instance, if you query Delivery Logs and want to return profile, the Resource entity will be Delivery Logs while the Targeting entity will be Profile (Delivery Log has a 1-1 relationship to Profile). In the former, the count will be the number of delivery logs fitting the criteria while in the later the count will be the number of Profile fitting the criteria on the Delivery Logs.

See also the documentation: https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/targeting-activities/query.html?lang=en#targeting-dimensions-and-resources 

You can do a quick test to convince yourself and use Preview in the Query activity to see the differences,

Hope this helps,

Thanks

Denis

 

    Terms & ConditionsAccessibility statement

    Loading footer...