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.

Sorting Fields Wizard

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:

1. Open the Sorting Fields Wizard: this can be accessed from the relation initial sort option.

2. 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.

3. 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.

4. Set Sort Order:

   • In the Selected Fields List, choose the sort order for each field by selecting either the Asc (ascending) or Desc (descending) radio button.

5. 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.

6. 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.

7. Copy Configuration (if needed):

   • If you want to duplicate the current sorting configuration for reuse, click the Copy button.

8. 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.