how to get @recipientClick from nms:delivery table

Forum|Forum|3 years ago
February 15, 2023
1 reply
1564 views

i am trying to do this:

const queryDef = {

schema: "nms:delivery",

operation: "select",

select: {

node: [

{ expr: "@recipientClick" }

]

}

};

const query = NLWS.xtkQueryDef.create(queryDef);

const mappings = await query.executeQuery();

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 ParthaSarathy

hi @arnav21 ,

You can get recipients click using expr= "[indicators/@recipientClick]"

Example,

var query = xtk.queryDef.create(
  <queryDef schema="nms:delivery" operation="select" >    
    <select>
      <node expr= "@id" />
      <node expr= "[indicators/@recipientClick]" />          
    </select>
    <where>  
       <condition expr="@id = 12345"/>
    </where>    
   </queryDef>
)
var result = query.ExecuteQuery();
for each (var output in result.delivery)  
{
vars.id = output.@id;
vars.recipientClick = output.indicators.@recipientClick; 
logInfo("id : " + vars.id);
logInfo("recipientClick : " + vars.recipientClick);
}

ParthaSarathy

Accepted solution

Community Advisor

hi @arnav21 ,

You can get recipients click using expr= "[indicators/@recipientClick]"

Example,

var query = xtk.queryDef.create(
  <queryDef schema="nms:delivery" operation="select" >    
    <select>
      <node expr= "@id" />
      <node expr= "[indicators/@recipientClick]" />          
    </select>
    <where>  
       <condition expr="@id = 12345"/>
    </where>    
   </queryDef>
)
var result = query.ExecuteQuery();
for each (var output in result.delivery)  
{
vars.id = output.@id;
vars.recipientClick = output.indicators.@recipientClick; 
logInfo("id : " + vars.id);
logInfo("recipientClick : " + vars.recipientClick);
}

~ ParthaSarathy S~ Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups