Avatar

Level 2

Hello @Manoj_Kumar_, I had tried the before without success.  Below is my updated code.  The data flows through the workflow appropriately but then when i attempt to reference the item in the alert activity (<%= formatDate(item.CreationDate, "%A %D %B %4Y") %>) it  appears blank.  Is there a change that needs to be made in the alert activity?

 

var query = xtk.queryDef.create (

<queryDef schema= "temp:query2" operation="select">
<select>
<orderBy >
<node expr="CreationDate" sortDesc="true"/>
</orderBy >
<node expr="@appointment"/>
<node expr="Registrations"/>
<node expr="Origin"/>
</select>
</queryDef>)

var itemsXML = query.ExecuteQuery();

vars.itemsXMLString = itemsXML.toXMLString()