Searching and filtering data are fundamental functions for a report.
The List Report supports two ways of search and filtering:
- Search Field is a field in the top left corner of a list report. Users can search data by entering a keyword in the search field. The report searches data across several fields according to the rule defined by developer.
- Selection Fields are input fields with value help dialogs on top of a list report. Each selection fields represent a filter for one property of the back end OData service. Users can customize selection fields of their own and save them as a variant.
For fields without a fuzzy search function, users must input the exactly same keyword as the data, or use wildcard characters (* and ?) to match data.
For fields with a fuzzy search function, if a user enters a typo in their keyword, similar results appear. In this example, the keyword is 'SBP', but SAP appears in the result.
This video provides more information on adding annotations for the Search field.
This video provides information on the relevance of the Search field and Value Help button from the end-user perspective.
It is a developer's responsibility to provide a value help dialog for the end user.
To enable a selection field, use @UI.selectionField.position as the element annotation on the field that needs to be a filter.
Even fields that do not display as a column can be used as a filter condition.
However, at runtime, end users can choose any fields as a filter by choosing Adapt Filters.