Filter products and product-event combinations using a SQL WHERE clause

You can set your user preference, Allow SQL WHERE Clause on the Signal Review Page, to allow use of a SQL WHERE clause to restrict rows that appear on the Products and Product-Event Combinations pages. For Product-Event Combinations tables, you cannot modify the WHERE clause for Alert type tabs (either tracked or informational).

To select table columns (variables) to include in the WHERE clause: from the Header Action menu () on the Products or Product-Event Combinations tables, click Columns. On the Columns dialog, enter the WHERE clause in the Where Clause text box. To copy an existing WHERE clause, click the Show Columns link.

1. In the left navigation pane, click the Signal Review icon ().
2. (Optional) From the Products By drop-down list, select a product grouping, then select a card to filter the Products table.
3. Click the product's Row Action Menu () and select View Product-Event Combinations, or click the product name or total count.
4. From the Manage Reference Data menu () on the top right, click Manage Views.
5. On the top left, click Columns. (This option is available only if you have the Manage Signal Views permission.)
6. From the Available Columns list, select one or more columns and move them to the Selected Columns list.
7. If you use a SQL WHERE clause, you must refer to the names of columns in the underlying database table, which might not be the same as the column names that appear on the page.
8. For the columns shown, specify the column names and sort order.
   • From the Column Name drop-down list, select the name.
   • From the Sort Order drop-down list, select Asc, to sort in ascending order, or Desc, to sort in descending order.
9. To use the layout as the default for your login group, select the Use current layout as login group default check box.
10. In the Where Clause text box, type or paste the SQL WHERE clause.
11. To include a column in the WHERE clause, click Show Columns and click the column name from the Select Table Columns dialog box.
12. Click OK.

The text, Rows are (filtered), appears above the table of products or * (modified) appears above the table of product-event combinations.