To ensure an improved sorting of large result sets in the Table widget, we have introduced the option for backend sorting, which applies to the data source types of External Data Source and Query Template.
When this feature is activated, a backend request is triggered every time when the column name is clicked and thus sorted.
To use the feature, you need to check the box for Enable sorting for data source in the respective data source configuration section.
In addition, you need to:
- define a Technical sorting name for the respective custom columns that will be sorted in this way, and
- define several parameters in the query template or add placeholders in the external data source URL respectively.
These are:
- sortField – defines a technical, editable sorting name of the column’s data source property
- sortDirection – defines the sorting direction with accepted values of asc, desc, ""
- sortDirectionNumber – defines the sorting direction as a number, with accepted values of 1, -1, 0
- sortDirectionSign – defines the sorting direction as a sign, with accepted values of +, -, ""
For further details, refer to Table widget and Configuring the Table Settings.