Query Window
Query Menu
This menu can only be accessed by clicking on the Menu button 
on the Query Toolbar
which is attached to the Query
Window.
| New Custom Query | Create a new custom query |
|---|---|
| Save As Custom Query | Make a copy of the current query (standard or custom) and save it as a new custom query. |
| Delete Custom Query | Deletes the current custom query. Standard queries cannot be deleted. |
| Run and Invert Result Set |
Run the current query - but instead of displaying all records that it matches in the Results Tab, display all records (of the same record type) not matched by the query. |
| Add Row Records to Named List | Queries based on a given record type
(which is most of them), produce a result set in which each row
shows information about a given record. These are 'row
records'. For queries of this type, this command will add
all these records to a Named List that you specify. So, if there
are 100 rows in the result set, there will be 100 records added to
the specified Named List. You cannot use this command with Fact queries as these are not record-based. |
| Remove Row Records from Named List | Similar to the previous command, but instead of adding the row
records to a given Named List, they are removed from it. |
| Set Flag on Row Records | Set a record flag that you specify on each 'row record' (see
above) in the result set. Can only be used with
Individual records. |
| Clear Flag on Row Records | Remove a record flag that you specify from each 'row record' (see above) in the result set. Can only be used with Individual records. |
| Add Selected Cell Records to Named List |
Adds every record corresponding to a cell in the current
selection, to a specified Named List. |
| Save Result Set As |
Saves the entire result set as either a PDF file, a Comma-separated CSV File, or as a text file. |
| Locate in Property Box |
Some cells in a query result set display calculated values. Others simply display the value of a particular item of data, taken directly from records in the current project. The latter is called 'Data-Linked Text' and by default it will display in black where ordinary text will be grey. If you select a cell containing data-linked text - which could be either a field or a record - this command will display that data item or record in the Property Box. Tip: If you right-click on a cell containing a
record, the dropdown menu will have a single command
which allows you to view that record in the Property Box. If you
do the same thing with a cell that contains data-linked text,
the dropdown menu will have two commands: and .You can also double-click on either kind of
cell as a fast way of viewing the record or field in the
Property Box. |
| Locate in All Tab |
This is similar to the previous command but whereas that command
will pick the most suitable tab to show the data in, this command
will always locate the item in the 'All' tab of the Property Box. |
| Options | Opens the Query Window tab of Preferences to set various fonts used for displaying queries on screen and printing, and also to set colours and print margins. |