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

Last updated

Was this helpful?