- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hello Sukrity_Wadhwa,
No I still have issue. By Considering that I want to send out a summery delivery table with Open, clicks etc, I created a simple workflow as showed below
The JS code has the query
var eQuery = xtk.queryDef.create(
<queryDef schema="nms:delivery" operation="select">
<select>
<node expr="@id"/>
<node expr="@internalName"/>
<node expr="@label"/>
<node expr="@state"/>
<node expr="@lastModified"/>
<node expr="[scheduling/@contactDate]"/>
<node expr="[scheduling/@validityDate]"/>
<node expr="[properties/@toDeliver]"/>
<node alias="@_progression" expr="Percent([indicators/@processed], [properties/@toDeliver])"/>
<node expr="[indicators/@successRatio]"/>
<node alias="@dataQuality" expr="Percent([indicators/@unknownUser], [indicators/@processed]) + Percent([indicators/@mailboxFull], [indicators/@processed]) + Percent([indicators/@invalidDomain], [indicators/@processed])"/>
<node alias="@reputation" expr="Percent([indicators/@refused], [indicators/@processed]) + Percent([indicators/@unreachable], [indicators/@processed])"/>
<node alias="@optOut" expr="[indicators/@optOut]"/>
<node alias="@optOutRatio" expr="[indicators/@optOutRatio]"/>
<node alias="@opens" expr="[indicators/@totalRecipientOpen]"/>
<node alias="@clickRatio" expr="[indicators/@recipientClickRatio]"/>
<node alias="@clicks" expr="[indicators/@recipientClick]"/>
<node alias="@errors" expr="[indicators/@error]"/>
<node alias="@errorRatio" expr="[indicators/@errorRatio]"/>
</select>
</queryDef>).ExecuteQuery();
instance.vars.deliveries=eQuery; // assign query result to instance.vars.deliveries;
in the Alert I have the code below
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" ""><HTML><HEAD>
</HEAD>
<BODY><%
var deliveries = new XML(instance.vars.deliveries);
for each (var delivery in deliveries )
{
vars.code=delivery.@label;
%><%
}
%>
<TABLE>
<TBODY>
<TR>
<TH align="left">Code</TH>
</TR>
<TR>
<TD><%= vars.code %></TD></TR></TBODY></TABLE></BODY></HTML>
if I try to run the workflow I have the error below
any idea?
Views
Replies
Total Likes