Show TOC

Function documentationGeneric Sort Filter Locate this document in the navigation structure

 

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.

Features

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.