Using control elements
The filter wizard view can quickly become confusing if several conditions are used with different controls. In this case, you can expand or collapse the conditions with your controls.
To expand or collapse controls.
-
Click View settings > Open filter wizard.
-
Perform one of the following tasks:
Displaying technical names of database columns
You can display the technical names of database columns instead of the display names.
To display technical names of database columns
-
Click View settings > Open filter wizard.
-
Click Show technical name.
This displays all the table and column names that occur in the filter wizard with their technical names.
-
If you would like to view the table and column display names again, click Show display.
Displaying filter conditions as SQL expressions
In the expert view you can view and edit filter conditions as SQL expressions.
To view a custom filter condition as SQL expression or to write one manually
NOTE: To open the expert view, you must own the role of administrator, auditor, or compliance & security officer.
-
Click View settings > Open filter wizard.
-
Click Expert mode.
If you have already created a filter, the filter condition is shown in the SQL editor as a SQL expression.
-
Perform one of the following tasks:
-
Click Apply.
Applies the filter.
Grouping and ungrouping columns
Grouping is offered for views with a large number of entries. You can group columns in the Auditing view on the Attestation policy column, for example.
MOBILE: This function is only available in the list view of the mobile interface.
To group by column or ungroup
-
Select the filter in the column you want and click Group by this column.
The entries are displayed in groups.
-
Open the group with .
This displays all the entries in the group.
- OR -
-
Delete the filter.
This dissolves the group.