Table View
The table is the default way Kvery shows your query results. It is an interactive grid: you can page through rows, sort by any column, and search across the data without touching your SQL.
Paging through rows
Large result sets are paginated so the page stays fast. A table starts with 25 rows per page and you move between pages with the pager controls. When the same query is shown on a small dashboard tile, the page size is reduced so the tile stays compact.
Sorting
Click a column header to sort by that column; click again to reverse the order.
If a particular column shouldn't be sortable — for example a pre-formatted label
column — disable it from your SQL with the
::nosort modifier.
Searching
Use the table's search box to filter rows by text. The search runs over the rows
already returned by your query. To stop a column from being searched (for
instance a column containing long JSON), mark it with
::nosearch.
Long values
To keep rows readable, long text is truncated inside the cell (around 75
characters) and the full value can be expanded on demand. You can also opt a
column into long-value handling explicitly with the
::long and ::long-value modifiers.
Column behaviour from SQL
Everything about how a column renders is controlled from your query using column modifiers:
| Goal | Modifier |
|---|---|
| Hide a helper column | ::hidden |
| Render a column as formatted JSON | ::json |
| Disable sorting | ::nosort |
| Disable searching | ::nosearch |
| Render raw HTML in a cell | ::trdata / ::tddata / ::tdata |
Row operations
When your query exposes an identifier, you can attach row-level operations
(for example edit or delete actions) using the ::operations modifier together
with posting data. This turns a read-only
table into a lightweight admin grid.