interface data_table sort
Allows you to arrange the cell contents in a data table field.
The data table is similar to a excel workbook where a categorized data can be stored as array, locating each item by its row and column index. The data table can be created on a dialog box and the data is displayed using this command.
The elements of a table can be sorted using the ‘table sort’ command
Format:
interface data_table sort |
|---|
data_table_name = | An Existing GI_data_table |
sort_column_index = | Integer |
affected columns = | Integer |
order = | Sort_order |
Example:
Interface data_table sort & |
|---|
data_table_name = | dtable & |
sort_column_index = | 1 & |
affected_columns = | 2 & |
order = | ascending & |
type_of_sort = | alphabetic |
Description:
Parameter | Value Type | Description |
|---|
data_table _name | An Existing GI_data_table | Specifies the name of an existing data table |
sort_column_index | Integer | Specifies the index of the column to be sorted |
affected columns | Integer | Specifies the range of columns associated with the column to be sorted |
order | Sort_order | Specifies the mode of sorting the cell contents |
Extended Definition:
1. The contents of a column can be sorted in ascending or descending order. The sorting can be numeric or alphabetical. Generally, the column will have one or more associated columns which will get affected due to reallocation of the column to be sorted. Hence, the associated column contents also need to be repositioned in accordance with the column sorted. This can be easily achieved by directly choosing the ‘affected columns’. Hence, there is no need of repositioning of the cell contents of associated columns.