Sorting a list by column
How column sorting works, which pages and columns sort, the shared ordering rules, and what a sort covers on a list that is still loading rows.
Most tables in the web app let you reorder rows by certain columns. This page lists which columns sort and what a sort does and doesn’t cover.
Sorting a column
A sortable column header has a small icon beside its name. A pair of carets means “click to sort by this column”. An up or down arrow means this column is the active sort, and which way it runs. A column without an icon doesn’t sort.
Clicks cycle through three states:
- The first click sorts by that column in its usual starting direction.
- A second click reverses it.
- A third click clears the sort, and the list goes back to its own order.
Click a different header at any point and the list sorts by that column instead.
Each column starts in whichever direction is most useful. A name or title column starts ascending (A to Z). A count, cost or past-date column starts with the highest or newest value first. A column holding a future date starts with the soonest first. That’s why Next run on Task schedules opens with the run that fires next, not the one furthest away.
The column that’s already showing
Many lists open with an arrow already showing, because the list comes in that order. Tasks shows Created, newest first. Members shows Name, A to Z. Clicking that column once reverses it. Clicking it again puts the default order back. A list with no arrow showing has no single column behind its order.
Sorting changes the order of rows, never which rows show. To get the list’s own order back, click through to the third state, or drop the sort from the page’s web address.
How rows are ordered
Every sortable column follows the same rules, so “alphabetical” and “highest first” mean the same thing everywhere:
- Text sorts without case sensitivity. “apple” and “Apple” land next to each other.
- A number inside text sorts as a number. “Item 2” comes before “Item 10”.
- A blank value sorts last in both directions, so an empty date or an unset field never crowds out rows that have one.
Which pages sort, and by what
Column names are the headers as they appear on screen.
| Page | Sortable columns |
|---|---|
| Tasks | Title, Priority, Creator, Created |
| Blockers | Task, Filed by, Filed at |
| Sessions | Agent, Device, Cost, Created |
| Sessions, “Sessions needing attention” list | Agent, Device |
| Task schedules | Title, Last run, Next run, Created |
| Wiki, All pages | Title, Level, Kind, Updated |
| Wiki, inside a folder | Title, Folder, Updated |
| Repos | Name, Created |
| Agents | Name, Last used, Operator, Agent role, Created |
| Devices | Device, Sessions, Last metrics, Created |
| All devices (your account) | Device, Owner, Sessions, Last metrics, Created |
| Skills | Skill, Version |
| Skills → Plugin sources | Plugin, Repo, Last sync |
| People → Members | Name, Role, Email |
| People → Teams | Name, Created |
| Optimisation → Surveys | Survey, Created, Updated |
| Optimisation → Surveys → Survey templates | Template |
| Reports → Costs, Model routing table | Stage, Actual, Would-have, Savings, Turns |
| Reports → Quality, Setups | Setup, Stage, Model, Decided, Rate |
| Reports → Observability, Slowest tool calls | Tool, Duration, Started |
| Reports → Observability → Tool time rows | Tool time, Calls, Sessions, Max, Errors, Cost (Estimated cost on some facets) |
| Observability → Alert rules | Name, Metric, Threshold, Last evaluated, Failures, Created |
| One alert rule’s page, Incidents | Opened, State, Peak |
| Settings → Workflows | Label, Stages |
| Settings → Stages | Label, Owner, Version |
| Settings → Variables | Key, Scope, Updated |
| Settings → Webhooks | URL, Last delivery, Created |
| Settings → Webhooks → Inbound endpoints | Name, Last delivery, Created |
| Settings → Network access, Workspace rules and Image build hosts | Target, Effect, Created |
A page or table not on this list doesn’t sort by column. That includes the panels nested inside a task’s, a device’s or a member’s own page. It also includes the ranked breakdown tables above the Model routing table on the Costs page. Their row order is the ranking, so there’s nothing to sort.
What a sort covers
Where the sort happens depends on the list.
- Tasks and Tool time rows sort on the server. The sort covers every matching row, however many there are, and Load more continues in that order.
- A short list always loads whole, so its sort covers every row. Skills, Settings → Workflows, the Model routing table, Quality Setups and Slowest tool calls work this way. Slowest tool calls re-sorts the top 50 calls the report returns.
- Every other list sorts the rows already loaded. When a list has more rows to load, a sort reorders only the rows on screen. A caption under the filter bar says so, for example “Sorted within 50 loaded rows” (with the list’s own noun in place of “rows”). Press Load more to bring in the rest. The loaded rows then re-sort with the new ones included. Rows you haven’t loaded can’t take part, so don’t trust the top of a sorted list until the Load more button is gone.
On Tasks, a parent and its children still nest as they always do. See Finding and tracking your work. Sorting orders the top-level tasks among themselves, and each parent’s own children among themselves. It doesn’t flatten the hierarchy.
From the command line
Column sorting is a web app feature, and most ch list commands have no sort option. They return rows in their own default order. Two commands take their own sort:
ch observability rows --by <facet> --sort <column> --dir <direction>orders the full row set for one facet. See Reading the Observability report.ch agent workload --team <team> --sort <key>orders a team’s workload. See Monitoring your agents.
The link carries it
The column and direction you pick travel in the page’s web address, like its filters. A sorted view is a link you can bookmark, reload or send to a teammate. See Sharing a view with a link for what else travels with it.
On most pages, Clear filters also resets the sort and returns the list to its default order. A few pages keep your sorted column, such as Blockers, the wiki, Costs and Alert rules. There, click the sorted header until the list is back in its default order.
Related guides
- Sharing a view with a link: everything else that travels in a list page’s web address
- Finding and tracking your work: the Tasks page filter bar, views and list in full
Last updated