Tables across the application share a common set of features for sorting, organizing, and interacting with data. Additional functionality may be available depending on the table size or purpose.
Common Table Features
All tables in the system support the following basic interactions:
Reorder Columns – Click and drag any column to rearrange its position.
Sort by Column – Click the header of a column to sort it. A directional arrow will appear to indicate sorting order.
Pagination and Column Visibility
Broadly, there are three types of tables in the application:
1. Large datasets such as Sampling Results, Industrial Users, or Permitting databases.
Advanced filter and search functionality
Column visibility controls (gear icon)
Export to CSV functionality
Row pagination tools
2. Some tables have fixed visible columns for smaller datasets, such as the Outfalls or Sample Report Configurations tables.
Columns can be rearranged
Sorting is enabled by clicking on column headers
Fewer rows expected, so no advanced search or filtering tools are included
3. Other tables allow for some customization, where the dataset may grow over time (e.g., Limits tables at an Outfall)
Includes basic sorting and column reordering
Adds filter options such as “Show Archived” for ease of review
Click the gear icon at the top left of the table to show/hide columns as needed
Exporting Tables
If the export icon is available, you can download the table to a CSV file:
The export will preserve any filters, column visibility, and sorting order
Search and Filter Options
Larger tables offer robust filtering tools via:
Search Bar – Type-based query builder that helps filter the table
Builder – A visual overlay for constructing multi-condition filters
Using the Search Bar:
1. Click the search bar to select a column
2. Clicking the search bar again allows you to choose a search criterion (e.g., contains, equals)
3. Enter the value and hit Enter to apply
4. You can add multiple search criteria in the search bar to refine your results and build a more detailed, targeted dataset.
5. Use "Clear" to reset the filters
Using the Filter Builder
Clicking the "Builder" button opens a visual interface:
Add multiple conditions using the “+” button
Remove filters using the “–” button
The table updates only after clicking Apply Advanced Filter
Switch freely between the builder and search bar; filters sync across both tools
Archived Data Toggle
For records that can be archived, filter visibility depends on the table setup:
With Search/Builder: Use the filter tools to search for archived data
Without Search/Builder: A checkbox labeled “Show Archived...” will appear
Watch the Video
This video explains:
How to sort and reorder columns
Adjusting visible columns
Searching and filtering using both methods
Exporting customized tables
When and where filters are available across different types of tables
Try it Out
Open the Sampling Results table
Reorder columns by dragging
Sort the table by any column
Toggle column visibility via the gear icon
Use the search bar to filter by an analyte
Open the builder and add a second filter
Click Apply Advanced Filter
Export the table to CSV
Open the file and confirm it matches your view