Avatar

Correct answer by
Community Advisor

Hi @wpomeroy ,

 

You should write

 

var query = xtk.queryDef.create (

<queryDef schema= "temp:query2" operation="select">
<select>
<node expr="@appointment"/>
<node expr="Registrations"/>
<node expr="Origin"/>
</select>

<orderBy >
<node expr="CreationDate" sortDesc="true"/>
</orderBy >
</queryDef>)

var itemsXML = query.ExecuteQuery();

vars.itemsXMLString = itemsXML.toXMLString();

 

sortDesc="true" will return descending sort

Thanks,

David

View solution in original post