Queries

Queries

Queries let you search, filter, and explore the data in your project. Open the Queries panel from Tools > Queries.

Query language queries

The drop-down at the top of the panel lists saved queries. Select one and it runs immediately, displaying results in the table below.

You can create your own queries using the built-in query language, a SQL-like syntax for searching people, families, sources, and more. Click New to start a blank query, or Edit… to open the query builder for the currently selected query.

Results can be viewed as a read-only table, an editable table (where the underlying data supports direct editing), or a detail view. Use the view mode switch on the toolbar to choose.

See Query Language for the full syntax reference.

Script queries

If you have Lua @query scripts installed (see Scripts), they also appear in the drop-down with a "Script:" prefix — for example, "Script: People Without Death Dates".

Navigating from results

Double-click any row in the results table to navigate directly to that record (so long as it is supported by the particular script or query).

Entry assistants

When editing cells in the results table or detail view, date, place, and age columns show a helper button beside the editor. Click the button (or press F2) to open an entry assistant for structured data entry — for example, a calendar-based date picker or a place search dialog. The assistant fills in the value for you.

Parameters

When a query uses @parameter placeholders (see Query Language), input fields appear between the toolbar and results. Each field is tailored to the parameter’s declared type — place parameters show a place search, date parameters show a calendar picker, and so on.

The query re-runs automatically when you move out of a parameter field, so results update as you fill in values.

Auto update

Enable Auto update on the toolbar to have the current query re-run automatically whenever the underlying data changes — useful for keeping a query visible while editing records.