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:

  1. Right-click anywhere in the grid and choose Filter > Advanced Filter from the pop-up menu. The Customize View - Advanced Filter window opens.

  2. If the Advanced Filter tab appears in the Design mode, click Switch to SQL Mode.

  3. In the SQL mode, configure the SQL WHERE clause, click OK.

ClosedClick here to show the examples of SQL WHERE clauses for the Computers grid

Meaning WHERE clause

Show computers with Windows 10 OS.

[Info_OS] Like N'%Windows 10%'

Show Windows 10 computers with CPU speed that is greater than 3 GHz.

([Info_OS] Like N'%Windows 10%') and ([Info_CPU_Speed] > 3)

Show Windows 10 computers with CPU Speed that is greater than 3 GHz located either in the ZEUS or NJ Domain.

([Info_OS] Like N'%Windows 10%') and ([Info_CPU_Speed] > 3) and ([Machine_Domain] IN ( N'ZEUS', N'NJ'))

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:

  1. 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.

  2. Clear the criteria box, click OK.