The Query Editor

The Query Editor is the window to your practice data. Using the Query Editor you can search a single table in the database or build complex searches across multiple tables.

The Query Editor is accessed by selecting Open > Patients, Records > Search.

The Query Editor lists the fields in the active table in the left-hand list (in this example the [Patients] table), and a selection of comparisons in the right-hand list. The value to search for is at the bottom of the window. The completed Query is displayed at the top of the window.

Query Editor

A Field, Comparison and Value must be selected/entered for the search to be valid (i.e. for Query button to become active).

Once a query has been built, there are two ways to perform the search:

1.	Query Clicking "Query" will search through all the records in the table(s) you are querying.

2.	Query in Selection Clicking "Query in Selection" will search through the current found set (i.e. the currently displayed selection of records). This is useful if you want to perform multiple queries to refine your search.