Sort List Data

AVEVA Work Tasks allows you to sort the list items in the ascending order (A to Z) or in the descending order (Z-A), Oldest to Newest, Newest to Oldest, Smallest to Largest and Largest to Smallest orders depending on the nature of the field. If you have thousands of list items in your console, you can locate a particular record by sorting the list items.

Before we start with this scenario, create an Employee Details list with three list items, Employee ID, Employee Name and Employee Address using TextInput controls.

Our objective is to enable sorting for the Employee Name column.

To sort list data

1. Launch the Employee Details list in the List Designer.

2. Click the Properties button corresponding to the Employee Name control. The Properties dialog box appears.

3. Select Yes for the Allow Sorting option and click Save. The List Designer page is displayed.

4. Click Submit. The Re-Generate Form dialog box is displayed.

5. Select No, do not regenerate the default form and click OK. The Manage List page is displayed.

6. On the Console Menu, select Lists and click Employee Details.

7. Right click the Employee Name column header.

8. Apply the required sort type. For Example, if you select Sort AtoZ, the Employee Names will be displayed in the alphabetic order A to Z.

   Note: The sorting order will vary depending on the field you have selected. If you select the Employee ID field, sorting order will be Smallest to Largest and Largest to Smallest.

In the above example, we have enabled sorting only for the list item Employee Name. When you click the column header of Employee ID or Employee Address, the sort option is disabled.