Introduction
By default, a user can sort individual columns in ascending or descending order by clicking the column header. However, you can also programmatically set a default sort order among multiple columns.
Prerequisites
The data table you want to sort must already exist.
|
Quick Steps |
| 1 |
Add any controls you want to use to sort the search results |
| 2 |
Open the results data table properties, then open the Advance section |
| 3 |
Click the Sort Expression icon |
| 4 |
Enter the Sort Expression for the desired columns, then click OK |
| 5 |
Save the form |
Detailed Steps
Step 1. Add any controls you want to use to sort the search results.
This example adds a Designation field to the Search Criteria section from the entity attributes.
Step 2. Open the results data table properties, then open the Advance section
You can use this functionality on any data table. This example uses the Search Results data table.
The Advance section is where you can set advanced properties for the data table.
Step 3. Click the Sort Expression icon.
This is where you can set the sort hierarchy.
Step 4. Enter the Sort Expression for the desired columns, then click OK.
Select a number for each column you want to use in the hierarchy. The application will sort 1 first, 2 second, and so on.
Step 5. Save the form.
Then, run the Preview. Xelence displays the form output. You can test your updated settings.
When you have previewed your form, it should look something like this. This example displays the data table records based on the sort sequence. The data table is sorted first by Designation, second by First Name, and third by Last Name.
What are the improvements over S3 Version 6?
This is an identical process.
Related Articles
Configure Data Table Grouping and Filtering
Configure Deleting Records
This post is part of the Lookup Form topic. Click here to open the Lookup Form Overview.
This post is also part of Controls and Buttons topic. Click here to open Forms Toolbox Controls
#Xelence
#Forms
#ControlsandButtons