<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Getting send indicator of delivery in a query in Adobe Campaign Standard Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444068#M14733</link>
    <description>&lt;P&gt;The query is set up of the following way:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Properties&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_0-1646990544992.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39156i0F9536AF0A1F1DE1/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_0-1646990544992.png" alt="LAR1985_0-1646990544992.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Target&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_3-1646992495304.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39159iD052DFAF7E680742/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_3-1646992495304.png" alt="LAR1985_3-1646992495304.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Additional data:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_2-1646990941808.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39158i604219ADE9CDB515/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_2-1646990941808.png" alt="LAR1985_2-1646990941808.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;And I get the following in "Open Transition":&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_5-1646992699364.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39161i2A17DD101E0DC72D/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_5-1646992699364.png" alt="LAR1985_5-1646992699364.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I think our example is different from yours because in our case, we use recurring deliveries, so we have, two records for "Agra" delivery, one for each day, we need but we need to extract the "sent" of the master delivery. We would like a&amp;nbsp; field like the following one (sent Master= the summary of the send of each delivery created in each execution of master delivery, example 1.6k=33+1,57k):&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_6-1646992981135.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39162i93D077AD24B60C0B/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_6-1646992981135.png" alt="LAR1985_6-1646992981135.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Fri, 11 Mar 2022 10:04:53 GMT</pubDate>
    <dc:creator>LAR1985</dc:creator>
    <dc:date>2022-03-11T10:04:53Z</dc:date>
    <item>
      <title>Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443906#M14727</link>
      <description>&lt;P&gt;Hello all,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to get the number of send in a primary delivery in a query. I have selected as target "Delivery" and in "Additional data", if I choose "dynamicIndicators/@dynamicSent", I get the following:&lt;/P&gt;&lt;P&gt;Label&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;DynamicSent&lt;/P&gt;&lt;P&gt;[2022/03/03] Name delivery&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 12&lt;/P&gt;&lt;P&gt;[2022/03/04] Name delivery&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 7&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;What I want, it is the following&lt;/P&gt;&lt;P&gt;Label&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; Sent&lt;/P&gt;&lt;P&gt;Name Delivery&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; 19&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have tried choosing in "additional data", the following "[masterKpis/@sumSent]", but I get the following error:&lt;/P&gt;&lt;TABLE&gt;&lt;TBODY&gt;&lt;TR&gt;&lt;TD&gt;&lt;DIV class=""&gt;&lt;DIV&gt;&lt;SPAN class=""&gt;&lt;SPAN class=""&gt;PGS-220000 PostgreSQL error: ERROR: INSERT has more target columns than expressions LINE 1: ...INSERT INTO wkf114074112_70_1 (iMasterKpisSumSent,iId) SELEC...&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN class=""&gt;Can someone help me?&lt;/SPAN&gt;&lt;/DIV&gt;&lt;DIV&gt;&amp;nbsp;&lt;/DIV&gt;&lt;DIV&gt;&lt;SPAN class=""&gt;Thanks in advance&lt;/SPAN&gt;&lt;/DIV&gt;&lt;/DIV&gt;&lt;/TD&gt;&lt;/TR&gt;&lt;/TBODY&gt;&lt;/TABLE&gt;</description>
      <pubDate>Thu, 10 Mar 2022 14:45:06 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443906#M14727</guid>
      <dc:creator>LAR1985</dc:creator>
      <dc:date>2022-03-10T14:45:06Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443922#M14728</link>
      <description>&lt;P&gt;The easy fix is to in you query select Primary = Yes.&amp;nbsp; That gives you an overall total for that delivery.&amp;nbsp; If you want a monthly total, you will need to change your recurring deliveries to aggregation period to a Month.&amp;nbsp; Your example indicates it is set to Day.&amp;nbsp; If you do the later then you can select only the current month totals by filtering the labels that have the current month and year.&lt;/P&gt;</description>
      <pubDate>Thu, 10 Mar 2022 15:30:19 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443922#M14728</guid>
      <dc:creator>johnwwilcoxmba</dc:creator>
      <dc:date>2022-03-10T15:30:19Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443950#M14731</link>
      <description>&lt;P&gt;Thanks&amp;nbsp;&lt;LI-USER uid="9165543"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have tried including in the query, Primary= "Yes"&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_0-1646930221216.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39138i499E9D6A372C3E51/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_0-1646930221216.png" alt="LAR1985_0-1646930221216.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;And in the output data I only get the proofs done:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Label&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Send&lt;/P&gt;&lt;P&gt;[Proof 10] Name Delivery 1&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;4&lt;/P&gt;&lt;P&gt;[Proof 1] Name Delivery 2&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 10 Mar 2022 16:42:11 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443950#M14731</guid>
      <dc:creator>LAR1985</dc:creator>
      <dc:date>2022-03-10T16:42:11Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443974#M14732</link>
      <description>&lt;P&gt;Under properties, is the resource and targeting dimension Deliveries (Delivery)?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Add&amp;nbsp;&lt;LI-USER uid="2449631" login="label"&gt;&lt;/LI-USER&gt; in additional data.&amp;nbsp; Then run the query with the next step paused.&amp;nbsp; Click on the #record count, click open transition, then data.&amp;nbsp; You should see this:&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnwwilcoxmba_0-1646938895007.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39140iFF68D513E7B92CD1/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="johnwwilcoxmba_0-1646938895007.png" alt="johnwwilcoxmba_0-1646938895007.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 10 Mar 2022 19:02:13 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/443974#M14732</guid>
      <dc:creator>johnwwilcoxmba</dc:creator>
      <dc:date>2022-03-10T19:02:13Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444068#M14733</link>
      <description>&lt;P&gt;The query is set up of the following way:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Properties&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_0-1646990544992.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39156i0F9536AF0A1F1DE1/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_0-1646990544992.png" alt="LAR1985_0-1646990544992.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Target&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_3-1646992495304.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39159iD052DFAF7E680742/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_3-1646992495304.png" alt="LAR1985_3-1646992495304.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Additional data:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_2-1646990941808.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39158i604219ADE9CDB515/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_2-1646990941808.png" alt="LAR1985_2-1646990941808.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;And I get the following in "Open Transition":&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_5-1646992699364.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39161i2A17DD101E0DC72D/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_5-1646992699364.png" alt="LAR1985_5-1646992699364.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I think our example is different from yours because in our case, we use recurring deliveries, so we have, two records for "Agra" delivery, one for each day, we need but we need to extract the "sent" of the master delivery. We would like a&amp;nbsp; field like the following one (sent Master= the summary of the send of each delivery created in each execution of master delivery, example 1.6k=33+1,57k):&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="LAR1985_6-1646992981135.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39162i93D077AD24B60C0B/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="LAR1985_6-1646992981135.png" alt="LAR1985_6-1646992981135.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Fri, 11 Mar 2022 10:04:53 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444068#M14733</guid>
      <dc:creator>LAR1985</dc:creator>
      <dc:date>2022-03-11T10:04:53Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444129#M14736</link>
      <description>&lt;P&gt;I don't see your primary = yes in the query logic.&amp;nbsp; I had that turned on which sums up in 1 delivery.&amp;nbsp; I do have recurring deliveries but they are removed and only shows the parent or primary delivery.&amp;nbsp; When you use Primary = Yes it will not show you single deliveries so I added a Label clause.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnwwilcoxmba_0-1647007467458.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39178i40585052247E7804/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="johnwwilcoxmba_0-1647007467458.png" alt="johnwwilcoxmba_0-1647007467458.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 11 Mar 2022 14:04:49 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444129#M14736</guid>
      <dc:creator>johnwwilcoxmba</dc:creator>
      <dc:date>2022-03-11T14:04:49Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444135#M14737</link>
      <description>&lt;P&gt;Try this logic instead.&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="johnwwilcoxmba_0-1647009722044.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/39180iC1ECCB5AC8EC7940/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="johnwwilcoxmba_0-1647009722044.png" alt="johnwwilcoxmba_0-1647009722044.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 11 Mar 2022 14:42:12 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/444135#M14737</guid>
      <dc:creator>johnwwilcoxmba</dc:creator>
      <dc:date>2022-03-11T14:42:12Z</dc:date>
    </item>
    <item>
      <title>Re: Getting send indicator of delivery in a query</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/445579#M14763</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="17479849"&gt;&lt;/LI-USER&gt;,&lt;/P&gt;
&lt;P&gt;Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know.&lt;BR /&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Thu, 24 Mar 2022 04:57:37 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/getting-send-indicator-of-delivery-in-a-query/m-p/445579#M14763</guid>
      <dc:creator>Sukrity_Wadhwa</dc:creator>
      <dc:date>2022-03-24T04:57:37Z</dc:date>
    </item>
  </channel>
</rss>

