dspMonitor

Define Where Clauses

Add a Where clause to a user report if the filtering requirements are more complex than those supported by the user filter options.

When Where Clause Manual is enabled, user filters are ignored and only the Where clause defined on the Vertical View of the User (Reports) page is used. If the Where Clause Manual field is not enabled, it is assumed that there is no Where clause and the report is not filtered.

To define a Where clause for a report:

1. Select Configuration > User Reports/Filters in Navigation pane.
2. Click Reports for User ID.
3. Click WHERE CLAUSE MANUAL check box to enable it.
4. Click Vertical View for User ID.

5. Click Edit.

   View the field descriptions for the User (Reports) page's Vertical View

6. Enter a filter in Where Clause field.
7. Click Save.