How to Create a Custom Query

There are 2 ways of creating a custom query. You can either create a brand new one. Or you can copy an existing query (custom or standard) and modify the copy. To do either you must first open the Query Window, which you can do by clicking on Work with Queries on the Tools menu, or by clicking on the Query Window button on the main toolbar.

Then, to create a new custom query, click on the Query Menu button at the end of the Query toolbar, and choose New Custom Query from the dropdown list that appears. Give the new query a name and select a record type (this will be the record type of all records found by the query).

To copy an existing query, select the query you wish to copy in the Query list at the top of the Query Window. Then click on the Query Menu button at the end of the Query toolbar, and choose Save As Custom Query from the dropdown list that appears. Give the new query a name.

Changes made to custom queries are saved as you make them. You can modify them whenever you want. By default, new custom queries are created with one column, giving the name of the record, and no filters. So a new unchanged custom query will simply return all records in the current file, of the relevant record type, when run.

To learn how to make changes to a custom query, see Query Window.

You can run a custom query from within the Query Window by choosing it at the top of the window and by clicking on the Run Query button in the Query toolbar. Or you can run it at any time by clicking on View > Custom Queries, and then choosing the query from the menu list.

Custom queries can be deleted either by using the Delete Custom Query command on the Query menu or by selecting View > Custom Queries > Delete Custom Query.

For further reading, see chapter 13 of the manual, Getting the Most From Family Historian.

The CHM file was converted to HTML by chm2web software.