This is an old revision of the document!


Query Window ~ Columns Tab

The Result Set will look like a spreadsheet or table of Columns and Rows, and the Columns tab determines what details will appear in the Columns. See Index for related topics.

Press F1 to get the Help page and see The Columns Tab for details of the options available.

Data Reference Fields are chosen using the Fields pane on the left. Click on any + sign to expand a sub-list, and having selected a Field, click on the Add Field as Column button > at the bottom. This will add a Heading and an Expression to the Columns pane on the right. Although these Columns are listed vertically, they will appear horizontally in the Result Set, and moving them up and down, actually moves them left and right in the results.

If you have created Text Schemes in Diagrams then these Expressions are almost identical, and similarly can include Functions. Look at other Queries and you will see how they use Fields and Query Functions. The Help page for the Query Window: Columns Tab has links to the help on Understanding Data References and Understanding Functions, but for an introduction see Understanding Data References and Understanding Functions.

Remember that many Data Reference Fields can have more than one instance, but only the first one is added by default. For example the Individual > Name field has an Expression of %INDI.NAME[1]%. If any Individual has Alternate Names then %INDI.NAME[2]% and %INDI.NAME[3]% will also exist, and these must be entered as extra Columns and the index adjusted to [2] or [3] by hand. It is easily overlooked that Attributes, Events, Sources, and many other fields often have multiple instances that need to be incorporated.

When using Query Type:Fact the =FactOwner(%FACT%,…) Function is one way of listing the Owner but the =GetRecord(%FACT%) Function is often a better solution.

You can always return to this tab and alter the columns later.

The options to Sort, Hide, Delete, Add, or Update entries are fairly self explanatory.