When you apply the advanced filter to a selected view,
You can create and apply the advanced filters as follows:
Design the filter by using the specially provided graphical filter builder, then apply the filter.
Directly specify the SQL WHERE clause for filtering the data, then apply the filter (recommended for advanced SQL users only).
NOTE about shared views: You can change the advanced filter of a shared view, but you cannot save your changes and update the shared view. To save your changes, create your local copy of the shared view. For details, see Working with views.
To use the configured filter criteria more than once, you can save the view with the applied filter (for details, see Working with views).