Sorting

Sorts the values in the column in ascending/descending order

Sort Values in Decision Tables

The sorting feature helps you rearrange the rows of your table in either ascending or descending order based on the values in a specific column.

How to Apply Sorting

1. Access Sorting: Click the arrow icon in the header of the column you want to sort, then select Sorting.

2. Choose Sort Order:

   • Sort by A-Z (ascending)

   • Sort by Z-A (descending)

Managing Sorting

• Only one column can be sorted at a time. Applying sorting to another column will reset the sorting of the previous one.

• When a column is actively sorted, a sorting icon will appear in the column header.

• To change the sorting direction, click the arrow icon in the column header, select Sorting, and choose the desired order.

• To remove sorting, click the arrow icon in the header, select Sorting, and choose Reset sorting.

Sorting Rules

When a column contains multiple data types, sorting follows specific rules. Here’s how DecisionRules handles sorting:

Descending Order

1. Text: Zz-Aa

2. Numbers: 9-0

3. Operator: ELSE

4. Number fields: (e.g., BTW)

5. Dates

6. Date fields: (e.g., BTW)

7. Functions

8. Operator: ANY

Ascending Order

1. Operator: ELSE

2. Numbers: 0-9

3. Text: aA-zZ

4. Number fields: (e.g., BTW)

5. Dates

6. Date fields: (e.g., BTW)

7. Functions

8. Operator: ANY

Example of Sort by A-Z option

Example of Sort by Z-A option