Query Window

Query Window: Rows Tab

The Rows tab is used to add or edit filters. Filters are used to select which records appear in the result set. Filters can have 4 kinds of basic condition. These are:

When Family Historian runs a query it applies all the filters to decide which rows will be included in the Result Set. If the first filter is one of the 'Add' ones, it initially makes the Result Set empty. If the first filter is an 'Exclude' one it initially puts all records (of the type used by the query) in the Result Set. Then it applies each filter sequentially to the Result Set.

For each 'Add If' filter it adds to the result set any records which aren't already in it, which match the condition of the filter.

For each 'Add Unless' filter it adds to the result set any records which aren't already in it, which do NOT match the condition of the filter.

For each 'Exclude If' filter it removes from the result set any result set records which match the condition of the filter.

For each 'Exclude Unless' filter it removes from the result set any result set records which do NOT match the condition of the filter.

After all filters have been applied in turn, whatever records are left in the Result Set are displayed in the Result Set tab of the Query Window.

General filters use an expression - that is, either a data reference (see Understanding Data References) or a function (see Understanding Functions) - and compare its value against a value specified in the filter.

Relations filters are used to check relationship conditions - such as whether a given Individual is a relative of a specified type of anyone who is already in the result set.

List filters are a convenient way of checking membership of Named Lists (see How to Use Named Lists).

Filters can be added or updated using the Add and Update buttons in the bottom right corner of the Query Window. Or they can be deleted by click on the the Delete button , or re-ordered by clicking on the Move Up and Move Down buttons .