Data Tables

Most data in the RALS™ SYSTEM is managed through a data table. Can’t find what you’re looking for in the RALS™ SYSTEM? There are several ways to manipulate a data table to find what you need.

Changing Displayed Columns

To show or hide columns:

1. Click
   
2. On the Columns tab, click to add a column
3. On the Columns tab, click to remove a column
   
4. Click Apply
   

There are two (2) ways to reorder columns in the data table:

• Click , then click the next to the column name to drag and drop, or
• In the data table itself, click and drag the column name

To replace columns:

1. Click
   
2. On the Columns tab, click on the column name
3. Search for the column you want to replace it with and click it
   • Only columns that adhere to your System Filters will be displayed
4. Click Apply
   

Filtering

Filters can be applied to narrow the data displayed in a data table.

There are three (3) ways to filter data:

• Click at the top of the data table and select the Filters tab to display all filter options, or
• Click on the individual column header for the data you want to filter, or
• Click on the top level toolbar and select the filters you want to apply across the entire system, see System Filtering

When filters have been applied, they are displayed above the data table.

To remove filters, click next to the filter you want to remove.

Note: Not all columns are filterable.

Searching

Searching quickly filters the data in the data table to a single selected record.

To search the data table, select a value from the autocomplete drop-down list at the top of the data table.

When a search has been applied, it is displayed as an applied filter.

To remove the search, click next to the search filter.

Note: Not all data tables are searchable.

Options

Options can be applied to enhance the workflow of the user.

Options include:

• Striping
• Refresh Data Table After Action

Striping

Striping can be applied to differentiate data table rows by color.

To configure data table striping:

1. Click
   
2. On the Options tab, select the desired striping type:
   • None - all data table rows are displayed with the same color (default option)
   • Alternating - every other data table row is displayed using an alternate color
   • Conditional - data table rows are colored based on a specific column’s value
     

Note: Not all columns support conditional striping.

Refresh Data Table After Action

When the Refresh Data Table After Action option is enabled, all data tables in the RALS™ SYSTEM will refresh after an action occurs.

To configure data tables to refresh after an action is selected:

1. Click
2. On the Options tab, select Refresh Data Table After Action:
   • Yes - Data Table will automatically refresh after an action
   • No - Data Table will not automatically refresh after an action

Note: This only applies to actions that would normally refresh data tables (such as the Review action on the Results Data Table).

Sorting

To change the sorting of a column, click the column name.

Note: Not all columns are sortable.

Resizing Columns

To resize a column:

1. Position your mouse over the column line so it becomes a double arrow
   
2. Click and drag the column to the desired size
   

Exporting

The data displayed in a data table can be exported and viewed in Microsoft Excel.

To export the data displayed in a data table:

1. Click at the top of a data table
2. Select Export
   
3. A file is downloaded in .tsv format
   
4. Open Microsoft Excel
   
5. Browse to find the .tsv file (Hint: In the file explorer, you might have to change the dropdown from All Excel Files to All Files)
   
6. Click Open
   
7. When the Text Import Wizard appears, click Finish
   

Note: If one or more rows in the data table are selected, only those rows will be exported.

Printing

The data displayed in a data table can be printed.

Note: Printing is not supported in Internet Explorer.

To print the data displayed in a data table:

1. Click at the top of a data table
2. Choose one of the following options for rows to print:
   • When no rows are selected, the following options are available for selection:
     • All rows from all pages
     • All rows displayed on the current page (this is the default option)
   • When one or more rows are selected, only the following read-only option is available:
     • Only the selected rows
3. After selecting an option, click Print
4. A new browser window will open with the data formatted for printing, with each relevant row from the data table transposed into a paired list of column names and column values
5. Use the browser’s print dialog to print this window

E-mailing

A data table can be e-mailed to RALS operators and/or external e-mail recipients.

To e-mail the data displayed in a data table:

1. Click at the top of a data table
2. Choose one of the following options for rows to e-mail:
   • When no rows are selected, the following options are available for selection:
     • All rows from all pages
     • All rows displayed on the current page (this is the default option)
     • A link to the current view
   • When one or more rows are selected, only the following read-only option is available:
     • Only the selected rows
3. Enter the recipient(s)
4. Optionally enter body text
5. Click Send
6. The selection of your choice will be e-mailed to the specified recipient(s)

System Filtering

System filtering allows for consistent filtering of all fields in the system via a single filter setting. This filter is persisted as an operator preference and will be applied each time the operator logs in, however these filters cannot be saved as part of a view.

• Click on the top level toolbar and select the filters you want to apply across the system

When a system filter has been applied, it is displayed above the data table in a different style than the table filters.

System filters can be removed via the on the top level toolbar or under the operator’s preferences dialog.