Query Builder

The Communicare Query Builder module is a sophisticated query by example (QBE) application that you can use to produce a large variety of specific user-defined reports.

Any user who has basic knowledge and experience with general Query tools will find Query Builder straightforward and relatively simple to use.

Once a Query Builder query (report) has been saved, it can be run from the Communicare Report menu. Query builder reports can be distinguished from other reports by the Query Builder iconQuery Builder icon displayed next to the report name on the menu.

Tip: This Query Builder topic contains only the basic information needed to "drive" Query Builder and is not intended to be a detailed query tool guide.

Communicare uses a relational database which simply means groups of related data kept together. This data is stored in tables, for example, patient details are stored in one table and provider details in another. These tables are related to each other (or linked) when there is a patient encounter or clinical visit. Each table consists of fields, such as Patient ID, Patient Forename, Patient DOB. Together the fields which make up a single patient's details or profile is known as a record.

Tip: These terms are often used interchangeably, but mean the same thing:
  • Table = File
  • Column = Field
  • Row = Record

Queries are the means of extracting specific records (which meet certain criteria) from one or more related tables. For example, a list of all male patients who visited the clinic in the last week who saw a particular provider. Queries can become very complex and sophisticated. Often the best method is to "build" them gradually to ensure the results are accurate and relevant.

Note: Never assume the results of your query are correct. Always verify them to ensure accuracy. For example, a query's result may return no records. This can mean that no-one meets the criteria set or there is an error in one or more of your criteria. Be cautious!

To open the Query Builder in Communicare, select Tools > Query Builder > Query Builder.

Useful information

When the report selects patient names or when the report selects services, use the following:

If you need to include deceased patients, the 'Or' condition for CURRENT_STATUS should read null.

See Also Access Control for Query Builder Reports, Report Naming.