Expand my Community achievements bar.

SOLVED

Second Highest Winning Delivery Needs to be Deployed

Avatar

Level 3

Hi Team,

I have a condition where I have four Deliveries and I need to deploy to the Second highest Open rate delivery.

The logic I am using is : A/B testing

Can you help me with the JS code that will pick the second winining delivery based on Open rate.

Thanks in Advance!

[ duplicate thread ] --> Second Highest Winning Delivery Needs to be Deployed

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

You didn't select @internalName in the query. Use a simple counter here:

var winner, i = 1;

for each (var row in res) {

    if (i++ === 2) winner = row;

}

View solution in original post

7 Replies

Avatar

Level 4

You posted your question in the Acrobat JavaScript forum. I moved it for you to the Adobe Campaign Classic forum.

Avatar

Level 3

Thank you, try67

My question is for Adobe Campaign, could you please forward it to campaign experts for speedy answer.

Avatar

Community Advisor

Hi,

Change the js so instead of operation="get" it's operation="select", for:

// query the database to find the winner (best open rate)

  var winner = xtk.queryDef.create(

  <queryDef schema="nms:delivery" operation="get">

Then iterate over the results, stopping at the second row.

Thanks,

-Jon

Avatar

Level 3

Hi Wodnicki,

Can you help me withe the code to iterate the result and stop at second row.

I tried with For Each loop but getting some error.

Regards,

Mustufa

Avatar

Community Advisor

Could you paste your code that's failing, with the error?

Avatar

Level 3

Hi Wodnicki,

The code I  am using is as follows:

  var winner = xtk.queryDef.create(

  <queryDef schema="nms:delivery" operation="select">

       <select>

         <node expr="@id"/>

         <node expr="@label"/>

     <node expr="@internalName"/>

       </select>

       <where>

        <condition expr={"@FCP=0 and [@internalName] in ('em123','em124','em125','em126') and @isModel=0"}/>

       </where>

       <orderBy>

         <node expr="[indicators/@estimatedRecipientOpenRatio]" sortDesc="true" />       

       </orderBy>

     </queryDef>)

    res = winner.ExecuteQuery();

   

for each (var row in res)

{

     logInfo(row.@internalName)

     }

I tried reading the rows through for each, not getting the seond highest delivery internal name though, please help ASAP.

Regards,

Mustufa

Avatar

Correct answer by
Community Advisor

You didn't select @internalName in the query. Use a simple counter here:

var winner, i = 1;

for each (var row in res) {

    if (i++ === 2) winner = row;

}