You use this action to apply a generic filter and/or a sort to a data set based on the returning columns in the data set. The sort can be alphabetical or numerical, and the filter is based on various conditional expressions.
The properties for this action are listed in the following table:
Property | Data Type | Access | Use |
Source | String | In and out | Contains the XPath to the data set to which you apply the filter. |
Sort Column 1-4 | String | In and out | The action sorts by the name of the column in the specified data set. The first parameter has the highest sort priority. |
Sort Type 1-4 | String | In and out | The data type of the value to be used for the sort. |
Sort Order 1-4 | String: Ascending or Descending | In and out | The ordering method. |
Filter Column 1-4 | String | In and out | The filter is applied to the specified column and you can filter up to four columns. |
Filter Type 1-4 | String | In and out | Defines the data type of the filter column. |
Filter Condition 1-4 | String | In and out | Specifies the conditional expression used for the filter. The conditions available are as follows: =, !=, <, <=, >, and >=. |
Filter Value 1-4 | String | In and out | The value that is displayed after the conditional expression that defines the filter. |
Output | XML | In and out | The XML output with the filtered data set, including messages. |
Success | Boolean | Out | Indicates whether the action succeeded or failed. If it failed, errors are displayed in the server trace log. |