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.
Exporting views
You can save a view in PDF or CSV format, or as a website for use as a report. This function is available at different points in your web application. For more information, see Exporting reports.
NOTE: You cannot export more than 100 000 data sets. If there are more data set, only the first 100 000 are exported.
To export a view
-
Click View settings > Export this view.
This opens the dialog Export this view.
-
Select one of the following options:
-
Export as PDF: exports the view as a PDF file.
-
Export as CSV: exports the view as a CSV file.
-
Display as website: exports the view as a report in HTML format.
-
(Optional) Enable the following check boxes:
-
All pages: All pages of the view were exported. If this setting is not enabled, only the current page is exported.
-
Remove header: Removes the first row of the table. This row contains the column names.
NOTE: This setting is only available if you selected the option Export as CSV in the previous step.
-
Click Export.
Exports the view.