- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Thanks @DavidKangni. This worked On a related note, do you know how i would go about only pulling a single instance of an item into an alert output? I am using the standard JS conventions below and then referencing them in the alert. But since i am using
<% var itemsXML = new XML(vars.itemsXMLString) for each (var item in itemsXML) { %> it is pulling in every single row. Is there any way for a specific node / item to only pull a single row? Do i need to define that as a seperate variable?
var query = xtk.queryDef.create (
<queryDef schema= "temp:union" operation="select">
<select>
<node expr="CreationDate" />
<node expr="@appointment"/>
<node expr="Registrations"/>
<node expr="Origin"/>
<node expr="WebRegistrations"/>
<node expr="ApptSum"/>
</select>
<orderBy >
<node expr="CreationDate" sortDesc="true"/>
</orderBy >
</queryDef>)
var itemsXML = query.ExecuteQuery();
vars.itemsXMLString = itemsXML.toXMLString()
Views
Replies
Total Likes