Filtering Entries
Use the filter panel to narrow down entries by column values.
Opening the Filter Panel
Click the Filter button in the toolbar. A panel opens on the right side of the entries table.
Creating a Filter
- Select a Column from the dropdown
- Choose an Operator (depends on field type)
- Enter a Value
- Click Apply
Operators by Field Type
| Field Type | Available Operators | Input Type |
|---|---|---|
| Text | Contains, Equals | Text input |
| Number | Equals, Greater than, Greater than or equal, Less than, Less than or equal | Number input |
| Date / DateTime | Equals, Greater than, Greater than or equal, Less than, Less than or equal | Date picker |
Multiple Filters
You can add multiple filter rows:
- Click + Add filter to add another filter condition
- All filters are applied together (AND logic)
- Each filter row has a remove (×) button
Clearing Filters
- Clear button — Removes all filter conditions and reloads all entries
- Close (×) — Hides the filter panel without clearing applied filters
Global Search
The magnifying-glass icon next to the toolbar (left of + Entry) is a different, faster way to search than either the Filter panel or per-column Table Search below: click it and it expands into a single text box, "Search all fields...", that matches your search term against every field's value on every entry in the SmartTable, across all pages — not just one chosen column.
- Matching is case-insensitive substring matching, debounced as you type
- It runs on the server over every row, together with any Filter-panel conditions, quick filters and the Show Deleted state already in effect — it narrows further, it doesn't replace or bypass those — and shows the first page of the result
- The search box collapses back to just the icon automatically when you click away with it empty, so it stays out of the way when not in use
Table Search
In addition to the filter panel, each column in the entries table has a built-in search bar. Type directly in the column header: the rows on screen narrow as you type, and once you pause the table reloads with every matching row from the whole SmartTable (case-insensitive "contains"). Clicking a column header's sort arrows likewise sorts all rows, not just the current page. Per-row columns of a table field (for example "Item 2") filter and sort within the current page only.
Quick-Filter Dropdowns
A System Admin can promote up to 4 fields to appear as always-visible quick-filter dropdowns directly above the entries table, instead of requiring the Filter panel to be opened at all — configured in SmartTable Settings → Display & Export → Filter Fields. Good candidates are whichever 2–4 columns get filtered on most often for a given SmartTable (e.g. Status, Department, Shift) — everything else stays reachable through the full Filter panel above. Each dropdown lists the values found across every entry you can see (up to 500 per field), not only the current page.