Almost all of the tables seen in the Dashboard have sorting and filtering functions provided by AG GridEXIT. Some tables also allow different sets of visible fields to be selected. Here’s a quick list of things to know about tables:
You can cycle table sorting through ascending, descending, or default by clicking on the heading of the column you want to sort by.
You can re-arrange columns by clicking the column headings and dragging the column left or right.
There is a ☰ menu icon at the top of most table columns. In cases where it appears on only some columns, note that some functions can be applied to all columns regardless of which column’s icon you use.
When you click on the ☰ menu the first tab allows you to pin the current column to the left or right side of the table.
The second ☰ menu tab allows you to enter a filter. To clear the filter, just delete the target text for the first filter term. Usually there will only be one term, but you can enter more than one.
After you enter one filter term, you can enter additional terms, with options to combine the terms with AND or OR.
Some tables have boxes at the top of each column to enter filter parameters. In the example below, the filter icons A and B indicate an active filter on both columns. The filter icon C is used to control the filter on the left hand column, which is numeric. The filter icon (C) lets you select “equal”, “greater than”, etc. There is no filter icon to modify the filter on the second column (D) as the second column contains text. The second columns filter is a simple “contains this text” filter.
The final ☰ menu tab lets you select which columns are visible.
Pre-filtered tables
Some tables in the Dashboard load with a filter in place by default. These filters are used to exclude information not relevant to the most common use cases of the filtered data. These cases will be highlighted in the relevant section of this documentation. Chemical list results (next topic) typically include an optional filter to omit multi-component results for example.