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 . (This option is available only if you have the Manage Signal Views permission.)
6. From the list, select one or more columns and move them to the 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 drop-down list, select the name.
· From the drop-down list, select to sort in ascending order, or , to sort in descending order.
9. To use the layout as the default for your login group, select the check box.
10. In the text box, type or paste the SQL WHERE clause.
11. To include a column in the WHERE clause, click and click the column name from the dialog box.
12. Click .
The text,
, appears above the table of products or * (modified) appears above the table of product-event combinations.