Designing an Advanced Filter by specifying an SQL WHERE clause
You can create, edit or remove the advanced filters by directly specifying an SQL WHERE clause.
NOTE: You can configure the advanced filters for your local views. For shared views, only your Alloy Discovery administrator can create and modify the advanced criteria for filtering data. You can change the advanced filter on the 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 configure an advanced filter by specifying an SQL WHERE clause:
-
Right-click anywhere in the grid and choose Filter > Advanced Filter from the pop-up menu. The Customize View - Advanced Filter window opens.
-
If the Advanced Filter tab appears in the Design mode, click Switch to SQL Mode.
-
In the SQL mode, configure the SQL WHERE clause, click OK.
Click here to show the examples of SQL WHERE clauses for the Computers grid
NOTE: When you switch to the Design mode, all the data entered in the SQL mode is lost.
To remove an advanced filter created by specifying an SQL WHERE clause:
-
Right-click anywhere in the filtered grid and choose Filter > Advanced Filter from the pop-up menu. The Customize View - Advanced Filter window opens. The Advanced Filter tab appears in the SQL mode.
-
Clear the criteria box, click OK.