Sort DataTable

This activity allows you to sort the data in a datatable based on the values of the specified columns. The values of the specified column can be sorted in ascending or descending order only.

 

Using Sort DataTable

  1. In the Canvas Tools pane, click DataTable to expand the tool and view the associated activities.
  2. Drag the Sort DataTable activity and drop on to the Flowchart designer area on the Canvas.

 

 

  1. In the Datatable Name list,  select the datatable you want to sort.
  2. Click the (Settings) icon. The Columns Definition window appears.

 

 

  1. Click Add to define a column you want to sort.
  2. In the Column Name list, select the column.
  3. In the Direction list, select Ascending or Descending depending on the order in which the table is required to be sorted.
  4. Click CONFIRM.

Sort DataTable Properties

The properties of Sort DataTable activity are listed in the following table and can be edited in the Properties grid on the right pane.

 

Property Name

Usage

Control Execution

Ignore Error

When this option is set to Yes, the application ignores any error while executing the activity.

If set to NA, it bypasses the exception (if any) to let the automation flow continue; however, it marks the automation status as failure, in case of an exception.

By default, this option is set to No. 

Delay

Wait After (ms)

Specify the time delay that must occur after the activity is executed. The value must be in milliseconds.

Wait Before (ms)

Specify the time delay that must occur before the activity is executed. The value must be in milliseconds.

Misc

Breakpoint

Select this option to mark this activity as the pause point while debugging the process. At this point, the process freezes during execution allowing you to examine if the process is functioning as expected.

In large or complex processes, breakpoints help in identifying the error, if any.

Commented

Select this option to mark this activity as inactive in the entire process. When an activity is commented, it is ignored during the process execution.

DisplayName

The display name of the activity in the flowchart designer area. By default, the name is set as Sort DataTable. You can change the name as required.