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.