Intellicus Enterprise Reporting and Business Insights 19.1

Sort Step

0 views June 28, 2020 0

Data that passes through a Sort step gets sorted based on the properties like Sort By Field, Criteria, etc. as specified. Sort is displayed on the Query Object Designer as shown below.

Figure 12: Sort Step

The properties to set are:

 Property Values Comments
Sort by Field Select field from list You can add multiple fields using Sort by and Then by lines based on priority of sorting in the order they are applied
Criteria Ascending/Descending Sorting criteria as either ascending or descending order
Case Insensitive Select/De-select Select = ABC is at same level as ABc

XYZ is smaller than abc

De-select = ABC is smaller than ABc

XYZ is bigger than abc