Sorting Fields Wizard
Overview
The Sorting Fields Wizard is used to define the sorting order for fields in a related dataset. This tool allows you to specify which fields to sort by and in what order, either ascending or descending, within the context of a relationship.
Sections
Fields Panel
Search Bar
Input field labeled type filter text
to filter the list of available fields by name.
Available Fields List
Displays the list of all fields in the related dataset that can be sorted.
Selected Fields Panel
Displays the fields that have been selected for sorting, along with their sort order. Each field shows:
Name: The name of the selected field.
Asc: Radio button to select ascending order.
Desc: Radio button to select descending order.
Action Buttons
Add Field ( >> )
Adds the selected field from the available fields list to the selected fields list.
Remove Field ( << )
Removes the selected field from the selected fields list and returns it to the available fields list.
Up
Moves the selected field up in the sorting order.
Down
Moves the selected field down in the sorting order.
Copy
Copies the selected sorting configuration.
Control Buttons
OK : Applies the sorting configuration and closes the wizard.
Cancel : Closes the wizard without applying any changes.
Sorting Fields
Here are the steps for sorting fields:
Open the Sorting Fields Wizard: this can be accessed from the relation initial sort option.
Filter Fields (Optional):
Use the search bar labeled
type filter text
to filter the available fields by typing part of the field name. This helps you quickly locate the field you want to sort by.
Select Fields for Sorting:
From the Available Fields List on the left, select the field you want to sort by.
Click the Add Field ( >> ) button to move the selected field to the Selected Fields List on the right.
Set Sort Order:
In the Selected Fields List, choose the sort order for each field by selecting either the
Asc (ascending)
orDesc (descending)
radio button.
Arrange Sort Priority:
Use the up and down buttons to arrange the fields in the desired sort priority. The top field in the list will be sorted first, followed by the next field, and so on.
Remove Fields (if needed):
To remove a field from the sorting criteria, select it in the Selected Fields List and click the Remove Field ( << ) button.
Copy Configuration (if needed):
If you want to duplicate the current sorting configuration for reuse, click the Copy button.
Apply and Save:
Once you have configured the sorting options as desired, click the OK button to apply the changes and close the wizard.
If you decide not to apply any changes, click the Cancel button to close the wizard without saving.
This wizard allows you to precisely define how your data in related tables is sorted, improving the organization and usability of your forms and datasets in Servoy.
Last updated