Appearance
Lists: search, filter, sort, saved views, export
Also known as
- table
- grid
- list view
- filter
- saved filter
- sort
- saved view
- columns
- column width
- resize
Every module opens on lists: purchase orders, invoices, employees, cases, items. They all work the same way, so what you learn on one list works on all of them: a search box, filter chips, sortable columns you can resize and hide, saved views, a CSV export and a pager. Select a row to open the record.
The parts of a list
| Part | What it does |
|---|---|
| All records (saved views) | Opens your saved views of this list. Shows the name of the view in use. |
| Search… | Searches the list's main text fields (number, name, reference …). Press / to jump into it. |
| Filter chips (+ Status, + Date …) | One chip per filter. Dashed when empty; filled with the value when set. |
| More filters | The filters that do not fit in the bar (after the first four). |
| Clear all | Removes every filter. |
| Columns and density (columns icon) | Show or hide columns; switch between Comfortable and Compact rows. |
| Export CSV (download icon) | Downloads the rows on the screen as a CSV file. |
| Column headers | Select to sort. Drag the right edge to resize. |
| Pager | "1–50 of 1,234", Rows per page (25, 50, 100, 200), Previous page, Next page. |
Search and filter
- Type in Search…. The list updates as you type.
- Select a dashed chip, for example + Status, and pick values. Depending on the filter you get:
- a list of options with checkboxes (pick one or several),
- a date range (Pick a range),
- Min and Max for amounts and quantities,
- a text box (press Enter to apply),
- Yes / No.
- Close the pop-up. The chip now reads, for example, Status confirmed, partially_shipped.
- To remove one filter, select the × on its chip. To remove them all, select Clear all.
If nothing matches you see "No records match these filters." with Clear filters.
The search, filters, sort and page are part of the page address. Copy the address from the browser to send a colleague the same filtered list, or bookmark it.
Sort
- Select a column header. The first click sorts ascending, the second descending, the third removes the sort. The diamond next to the header shows the direction (hover for "Sorted ascending" / "Sorted descending").
- Hold Shift while you select a second header to sort by it as well.
Some columns (computed values, actions) cannot be sorted; their header is plain text.
Resize, hide and reorder columns, change density
- Point at the right edge of a column header until the cursor changes, then drag. The column keeps its width the next time you open the list.
- Select the columns icon (Columns and density).
- Untick the columns you do not need. Greyed-out columns, such as the document number, cannot be hidden.
- Under Density, choose Compact to fit more rows on the screen.
Save a view
A saved view remembers the search, the filters and the sort of a list under a name, for example "Open orders this month".
- Set up the list the way you want it (search, filters, sort).
- Select All records at the start of the filter bar, then Save current view….
- Enter a Name and select Save view.
To use it, select the views menu and pick the view by name; All records goes back to the unfiltered list. To delete the view in use, open the menu and select Delete “name”.
Export the list
- Filter and sort the list, and show the columns you want in the file.
- Select the download icon (Export CSV).
The browser downloads a CSV file named after the list with the rows on the screen (the current page) and the visible columns. It opens in Excel, LibreOffice or Google Sheets, Arabic text included. To export more rows, set Rows per page to 200 first, or use:
- the Reports catalogue: every report exports to CSV, Excel and PDF,
- Data export in Analytics for whole datasets,
- Import and export in Settings for master data in import format (Imports and exports).
Work with several rows at once
Lists that offer bulk actions show a checkbox column. Tick rows (or Select all rows in the header); the filter bar shows "n selected" and the actions, for example approving timesheets in Time & attendance, converting planned orders in an MRP run or converting planned transfers.
Use a list with the keyboard
| Key | Does |
|---|---|
| / | Jump to the search box. |
| Tab to a row, then ↓ / ↑ | Move between rows. |
| Enter on a row | Open the record. |
See Keyboard shortcuts reference for the rest.
Where lists appear
Every module's list pages use this list, for example:
| Module | Lists |
|---|---|
| Finance | Journal entries, Vendor bills, Invoices, Customers |
| Procurement | Requisitions, Purchase orders |
| Sales & CRM | Leads, Quotes, Sales orders |
| Inventory | Goods receipts, Shipments, Adjustments |
| Manufacturing | Work orders, Bills of materials |
| People | Employees, Leave |
| Projects | Projects, Timesheets, Expense claims |
| Quality, Service, Assets | Inspections, Cases, Asset register |
| Catalogue | Items |
Lists inside a record's tab (for example the planned orders of an MRP run) have search, filters, sort and the pager but no saved views, and their state is not kept in the page address.
Limits and things to know
- Saved views, column widths, hidden columns and density are stored in this browser. They are yours only, and they do not follow you to another computer or browser. To share a filtered list, share its address.
- Export CSV exports the current page only, not every matching record.
- Very long pages (more than 200 rows) scroll smoothly because only the visible rows are drawn; use Ctrl F only on shorter pages.
- What a list shows depends on your permissions and, where it applies, on the legal entity selected in the top bar (Legal entities and currencies).
