How to log into journal and store open ratio of deliveries using javascript | Community
Skip to main content
akashaj7696
akashaj7696
New Participant
March 9, 2021
Solved

How to log into journal and store open ratio of deliveries using javascript

  • March 9, 2021
  • 2 replies
  • 2150 views

Hi Everyone,

 

I'm facing an issue in displaying and storing the value of open ratio using JavaScript. I have used the below code, please let me know where i'm wrong.

 

// query the database to find the winner (best open rate)
var winner = xtk.queryDef.create(
<queryDef schema="nms:delivery" operation="get">
<select>
<node expr="@id"/>
<node expr="@label"/>
<node expr="@internalName"/>;
<node expr="[@operation-id]" alias="operationId2"/>
<node expr="[indicators/@estimatedRecipientOpenRatio]" alias="ratio"/>
<node expr="[indicators/@totalRecipientOpen]" alias="estimated"/>;
</select>
<where>
<condition expr="@internalName='DM187125'"/>
</where>
</queryDef>).ExecuteQuery();

for each (var w in winner){
vars.ratio = w.@ratio;
logInfo("The value of open ratio is " +vars.ratio); - This displays blank.
logInfo(winner); - This displays all the values in the journal.
}

Any help would be appreciated.

 

Thanks,

Akash

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 _Manoj_Kumar_

@akashaj7696 

 

Try this:

 

logInfo("The value of open ratio is " +""+vars.ratio+"");

2 replies

_Manoj_Kumar_
_Manoj_Kumar_Accepted solution
New Participant
March 13, 2021

@akashaj7696 

 

Try this:

 

logInfo("The value of open ratio is " +""+vars.ratio+"");
     Manoj     Find me on LinkedIn
    akashaj7696
    akashaj7696Author
    New Participant
    March 13, 2021
    How to use this? can you explain?
    kapilKochar
    kapilKochar
    New Participant
    March 10, 2021

    Hi Akash,

     

    Try this this should work inside for loop and rest of your code is fine

     

    for each (var w in winner.ratio)

    {
    logInfo("The value of open ratio is " + w);
    }

     

    Thanks,

    Kapil Kochar

    akashaj7696
    akashaj7696Author
    New Participant
    March 10, 2021

    Hi Kapil,

    Appeciate your help.

    I used the below code but i still get blank.

     

    // query the database to find the winner (best open rate)
    var winner = xtk.queryDef.create(
    <queryDef schema="nms:delivery" operation="select">
    <select>
    <node expr="@id"/>
    <node expr="@label"/>
    <node expr="@internalName"/>;
    <node expr="[@operation-id]" alias="operationId2"/>
    <node expr="[indicators/@estimatedRecipientOpenRatio]" alias="ratio"/>
    <node expr="[indicators/@totalRecipientOpen]" alias="estimated"/>;
    </select>
    <where>
    <condition expr="@internalName='DM187125'"/>
    </where>
    </queryDef>).ExecuteQuery();

    for each (var w in winner.ratio)
    {
    logInfo("the winner is" +w);
    }

     

    Thanks,

    Terms & ConditionsAccessibility statement

    Loading footer...