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.
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).
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.
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.
Both columns also have sorting and filtering options available on the column header dropdown.
