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:
Click Collapse all in the Filter wizard.
Click Expand all if the controls are collapsed.
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.
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:
Edit the SQL expression in the field.
Enter the SQL expression in the field.
Click Apply.
Applies the filter.
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.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center
