Every list in the Solavel apps can be sorted by clicking a column header: newest or oldest first, A to Z, smallest or largest amount. This works the same way in SolaCount (Simple and Professional), SolaHR, SolaStock, SolaProjects and the Solavel Portal.
#How to sort
- Click a column header, for example Date, Number, Customer or Amount. The list is sorted from lowest to highest (oldest dates, A to Z, smallest amounts first). A ▲ appears next to the header.
- Click the same header again to reverse the order. The arrow changes to ▼.
- Click it a third time to return to the page's normal order (usually newest first).
Headers you can sort show a faint ⇅ when you point at them or reach them with the keyboard. Columns without it (buttons, checkboxes, pictures, notes) are not sortable.
With a keyboard: press Tab to reach a header, then Enter or Space to sort. Screen readers announce the current order ("sorted ascending").
#Example
Palm Grove Furnishings LLC has 40 invoices. Layla Haddad wants to see the largest unpaid amounts first:
- Open the invoices list.
- Click Balance due once: smallest first.
- Click Balance due again: the largest balance, for example Bayside Café's AED 1,575.00, is now at the top.
#Long lists with several pages
On lists split into pages, the whole list is sorted, not just the page you see. Changing the order takes you back to page 1. Paging, filters and search keep your chosen order.
#The order is not remembered
Your chosen order stays while you page, filter or search. When you open the page again, it starts in its normal order. Nothing is saved to your account.
#How values are compared
| Column type | Order |
|---|---|
| Dates | Oldest to newest (▲), newest to oldest (▼) |
| Amounts, quantities, percentages | Smallest to largest (▲), largest to smallest (▼) |
| Names, numbers, codes, status | Alphabetical in your language, with numbers in natural order (INV-2 before INV-10) |
| Empty values | Always last, in both directions |
Amounts are sorted by their value. On lists that mix currencies, the number is compared, not its value in your base currency.
#What is not sortable
Some tables keep a fixed order because the order itself has meaning:
- document lines on invoices, bills, orders and other documents (the order you entered them);
- statements and ledgers with a running balance (they must stay in date order);
- financial statements and report layouts (profit and loss, balance sheet);
- editable grids and forms;
- a few columns calculated when the page opens, such as an invoice's remaining balance on some lists, or salary columns hidden by permissions.
In SolaCount's Chart of accounts, sorting keeps the account tree: accounts are sorted within each parent group.
#If you see…
| What happens | Why |
|---|---|
| A header has no ⇅ and nothing happens on click | That column is not sortable (see above). |
| The order went back to normal | You opened the page again or followed a link. The order is not saved. |
| You are back on page 1 after sorting | This is expected; the first page now shows the top of the new order. |
Related: Sidebar and navigation, Search, Languages and Arabic.