Working with Tables
Filtering, sorting, pagination, cell selection, keyboard shortcuts, pins and data freshness.
Every registry table in Qope behaves identically. Learn it once.
Filtering
Filters live in the column headers and in the filter panel.
Multi-select filters
Most categorical columns open a searchable popover listing the available values. Tick as many as you want -- multiple values are combined with OR. The header shows a count when more than one value is selected, and a Clear action removes them.
Multi-select values appear in the URL joined with a pipe, for example ?state=NY|NJ|CT.
Search filters
Some high-cardinality fields (generic name, brand name, NDC, NDC description) use a search filter instead of a value list, because listing every value would be useless.
Date filters
Date columns provide a month selector and a year selector as a pair. Filter by year alone, month alone, or both.
Default filters
A few tables ship with a default filter so the first view is useful rather than mixed. The Providers table defaults to entity_type = Individual, and offers an Individual / Organization switch in the toolbar. Switching it also changes which columns are shown -- organisation name and subpart for organisations, personal name fields and gender for individuals.
Clearing
Clear an individual filter from its header, or clear everything from the filter panel.
Sorting
Click a column header to sort ascending, click again for descending. Sorting is server-side, so it sorts the whole result set, not the current page. The sort field and direction appear in the URL.
Each table has a default sort field, applied when you have not chosen one.
Pagination
Page size options are 25, 50 and 100 rows; 25 is the default. You can set your preferred default page size in account settings.
Total row counts are shown alongside the pager.
Selection and copying
Tables behave like a spreadsheet. Click a cell to focus it, then:
| Action | Shortcut |
|---|---|
| Navigate cells | Arrow keys |
| Jump to edge | Ctrl + Arrow |
| Extend selection | Shift + Arrow |
| Select to edge | Ctrl + Shift + Arrow |
| Row start / end | Home / End |
| First / last cell | Ctrl + Home / End |
| Jump a page | Page Up / Page Down |
| Select column | Ctrl + Space |
| Select row | Shift + Space |
| Select all |