RQL: a view written as a sentence — Writing one

• Start with the table's name, then where and your conditions, then optionally sort by a field followed by asc or desc. • Join conditions with and (every one must hold) or or (any may) — one or the other in a statement, like the filter bar's own AND/OR switch. • A field whose name has a space in it, and a field on a linked table, go in braces: {Unit Price} > 10, {Company.Region} is "North West". • Quote a value that has a space in it: Stage is "Closed Won". • A list goes in square brackets: Stage in [Won, Lost]. What can follow a field depends on its type: • Text — is, is not, contains, does not contain, starts with, ends with • Numbers — >, <, >=, <=, between 10 and 50 • Dates — before 2026-10-01, after, in last 30 days, in next 7 days, between • A single choice — is, is not, in [ … ], not in [ … ] • Checkboxes — is true, is false • People and multiple choices — has, does not have • Any field — is empty, is not empty