Skip to content

Filters, sorts and groups

Each view has its own filter, sort and group. They change only what that view shows. They never change your entries.

The settings

Setting What it does Example (a “To do” view of Tasks)
Filter Shows only entries that match. Done is not ticked
Sort Puts entries in order. Several sorts apply one after another. Due date, soonest first; then Title, A to Z
Group Splits entries into sections, or into columns on a board. By Project
Group order The order of the groups. Launch, then Website, then Other
Hidden fields Fields this view does not show. Hide Notes
Calendar date (calendar views only) Which date places each entry. Due date, not Entry date
Totals A count or sum shown with the view. “5 open”

Filters

  • A filter is one or more conditions: a field, a test and a value (“Distance is more than 5 km”).
  • Conditions combine with and and or, in groups.
  • You can filter on any property, on the built-in fields (Title, Entry date, Created at, Updated at, Parent), and, in a global collection, on its columns.
  • A new view has no filter, so it shows every entry of its collection.

The tests for each kind of field are the same as in Kaizendex v1:

Field Tests
Text, Title contains, does not contain, starts with, ends with, is, is not, is empty, is not empty
Number is, is not, more than, less than, at least, at most, is empty, is not empty
Checkbox is ticked, is not ticked
Date, Entry date before, after, on, is empty, is not empty
One tag is, is not, is any of, is empty, is not empty
Several tags contains, does not contain, is any of, is empty, is not empty
Relation is, is not, is any of, is empty, is not empty
Collection (in a global collection) is, is not, is any of

A test you set in a group stays in that group. It never moves out on a reload.

In a block: this entry’s date

A Chart or View block inside an entry has one more filter: this entry’s date. Only these blocks have it. It shows only the entries whose Entry date falls on the Entry date of the entry that holds the block, or inside its date range.

Example: the Diary day “28 Oct” holds a View block of Workouts with this filter. It lists only the workouts of 28 Oct. A holiday entry from 1 to 14 Aug, with the same block, lists the workouts of those 14 days.

Instant results

When you tick a task in a “To do” view, it leaves the list and the counter drops from 5 to 4 in the same frame. The screen runs the same filter, sort and total rules as the app’s engine, so the result is right at once and never jumps a moment later. This holds for empty values, dates, “contains” and accents too.

A total that needs data the screen does not hold (for example a median over 90,000 entries) keeps its last value until the engine’s answer arrives. It never shows a wrong guess.

Sorting by date

The feed shows newest first unless you add a sort. Entries are ordered by their Entry date, in the time zone where they happened.