Arrange table columns

1. From a Signal Review page, from the Header Action menu () for a table, click Columns. On other pages, click the Columns link.
2. Select columns to include in the table from the Available Columns list and move them to the Selected Columns list using the arrow buttons.

   If a table includes a lot of columns or the columns contain long values, the entire table may not fit across your browser window. Scroll to the right to see the rest of the table.

3. To change the order in which columns display in a table, in the Selected Columns list, click the column name and:
   • Click to move the column up in the list.
   • Click to move the column down in the list.
   • To move multiple columns, hold down the Ctrl key while you click the column names, and then click the up or down arrows.
4. To replace your choices with the Oracle Empirica Signal defaults, click Reset in the Columns dialog box. For the all tables, except Product-Event Combinations, the table columns and sorting return to the default values. For the Product-Event Combinations table, the Reset button in the Columns dialog resets to whatever was selected when you opened the dialog. To reset a Product-Event Combinations table to the default settings, from the Header Action menu (), click Reset View to Default.
5. Specify the sort order.

   If you sorted the table by clicking column headers, that sort order appears in the Column Name and Sort Order fields. To specify a sort order:

   1. From the Column Name drop-down lists, select a column name for up to three columns.
   2. From the Sort Order drop-down list, select Asc (ascending order: A-Z, 1-9) or Desc (descending order: Z-A, 9-1).

      If you are managing columns and you have checked the Allow SQL Where Clause on the Signal Review page check box on the Set User Preferences page, you can specify a SQL WHERE clause to filter rows on the Products table. For the Product-Event combinations table, this is only available for scripted signal configurations and added tabs.

6. For all tables, except the Product-Event Combinations table, if you have the Administer Users permission, you have the option to make the current layout the default for all of the users in your login group. This replaces the default table layout supplied by the application with your current layout for any user who has not yet arranged that table.
7. Click OK.

   Oracle Empirica Signal saves your arrangement of columns and rows and uses it as a default for the Products or Product-Event Combinations tables for the selected signal configuration until you change the arrangement.

   Note:

   When you initially display the Products table or Product-Event Combinations table, the columns shown and the sort order within the table reflect the current selections. Any changes you make are retained for that configuration.

Impact of multiple sorts on the Products table

1. Hover over an unsorted column header. A sort arrow appears indicating the initial sort order.
   • Dates and numbers are sorted in descending order.
   • Strings are sorted in ascending order.
   • The sort arrow is displayed for primary, secondary, and tertiary sorted columns.
2. Hover over a sorted column header and it continues to show the current sort direction.
   • The primary arrow is black. Secondary and tertiary arrows are gray.
   • The tooltip for a sort arrow indicates the new sort direction such as "Sort Interaction Descending" or "Sort Interaction Ascending."