Filtering the data
You can set the filter so that data for a specific entity is shown.
- At the upper right corner of the table, click the Grid settings.
- Select Show Filter Row. A new row is displayed below the table heading, each column has empty text fields.
-
Specify a keyword on any of the fields.
For example, assume that you are in the Accounts window. Specify a city under the City column to show accounts that are based in a specific city. You can filter several columns simultaneously.
-
Click Filter Menu and click
Clear Filter to reset the filter.
Note: When SQL Filter paging is enabled, only the first 50 records are displayed. You have an option to show the remaining data when you scroll down the list.
To enable SQL Filter paging, contact your system administrator.