Solavel Docs
English

Sort tables

Last updated

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

  1. 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.
  2. Click the same header again to reverse the order. The arrow changes to ▼.
  3. 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:

  1. Open the invoices list.
  2. Click Balance due once: smallest first.
  3. 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.