Sort Table Group Action

Event Function: SortTableGroup

The Sort Table Group action allows the rows included in a table sort group in a specified table to be sorted by the method indicated.

Using the Events tab

Under Enter Example

Run Skip Condition

If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed.

Table Name

The table label of the table to be sorted. Table name can be selected from the drop-down list or entered as a calculation.

"ABC"

Sort Group

The label for the table sort group to be sorted. The name can be selected from the drop-down list or entered as a calculation.

"Revenue"

Order

"Ascending"

"Descending"

"Manual"

"Ascending" Ascending Order

Syntax (if entering it in the Equation bar)

ACTION("SortTableGroup",expr1,expr2,expr3)

Where

expr1 = entry under Table Name

expr2 = entry under Sort Group

expr3 = entry under Order

How the example will appear in the Equation bar

ACTION("SortTableGroup","ABC", "Revenue", "Ascending")

Sorts all the rows in the table sort group in ascending order using by the column defined as the primary sort group in the table sort group.

Notes

  • Using this event also sorts any other sort groups (table, paragraph or section) linked to the sort group in the event.
  • Table sorts cannot be done on tables that span more than one section since sorting the table could require rows not in the section be sorted above rows that are in the section. When this happens, CaseView displays an error and the sort will not be completed.

Related Topics