Sorting Data in the Output

You can sort the data in the output according to certain criteria, either in ascending or descending order.

You enable sorting by declaring the <Sorting> element in the input XML. Within the <Sorting> element, the sorting criteria are defined in the <Field> element.

Element	Description
`Sorting`	Sorting Contains the following elements: `Field`
`Field`	Contains the following elements: `Name` `Order`
`Name`	Sorting criterion Note: The possible values are case-sensitive. Possible values: `StartedAt`: Start date `FinishedAt`: End date `ProcessInstanceId`: ID of the process `ProcessPath`: Process path `ParentProcessInstanceId`: ID of the parent process `ParentActionId`: ID of the parent process step `RootProcessId`: ID of the root process `HostName`: Host name `TotalTime`:Total duration `Status`: Status
`Order`	Sorting order Note: The possible values are case-sensitive. Possible values: `ASC`: Ascending `DESC`: Descending

Example

Input

XML

<?xml version="1.0" encoding="UTF-8"?>
<Query>
  <ProcessFilterByPath>
    <ProcessPath>1/MyProject/Processes/MyProcess.wrf</ProcessPath>
  </ProcessFilterByPath>
  <Sorting>
    <Field>
      <Name>StartedAt</Name>
      <Order>ASC</Order>
    </Field>
  </Sorting>
</Query>