Sample Applications / Order Form / Total and Subtotal
Enable Sort and Filter

Currently, the new fields Total and Subtotal do not allow sorting or filtering. You can see this on the grid of Order Form – the Total column does not have a dropdown available, and the field is not displayed as an option in the advanced search bar.

'Total' field in Order Form is not searchable or filterable.

Let’s enable sorting and filtering for these two fields. Switch back to the Project Explorer, and double-click on Orders / Fields / Subtotal* (Currency, read-only).

Subtotal field in the Orders controller of the Project Explorer.

Change the following settings:

Property New Value
Allow Query-by-Example true
Allow Sorting true

Press OK to save the field. Now, double-click on Total field node.

Total field in the Orders controller of the Project Explorer.

Make the same changes:

Property New Value
Allow Query-by-Example true
Allow Sorting true

Save the field, and regenerate the application. On the Order Form page, you can see that the Subtotal and Total fields are now available as options on the advanced search bar.

Subtotal and Total available as options on the advanced search bar.

Both columns also have sorting and filtering options available on the column header dropdown.

Subtotal and Total column header dropdowns are now enabled.