Common Simple Query Filters

Follow

Simple Queries allow for less complex filters to be used compared to Extended Queries. The following filters can be used when creating a Simple Query either via the Simple Query Wizard, or when creating a User-Defined Query.

Simple Queries use the following Operators:
mceclip0.png

Equals

Returns all records where the the selected column equals the text entered

Greater Than

Returns all records where the selected column are higher than the text entered

Less Than

Returns all records where the selected column are less than the text entered

> Than or Equal

Returns all records where the selected column are higher than and including the text entered

< Than or Equal

Returns all records where the selected column are less than and including the text entered

Doesn't Equal

Returns all records where the selected column doesn't equal the text entered

 

Simple Queries also use the following Logical arguments:
mceclip2.png

And

Returns all records where all arguments are met

Or

Returns all records where either arguments are met

 

Last Visit

A patients' Last Visit is the last date treatment was entered in the Treatment tab. Non-Reporting and Non-Treatment items are excluded.
mceclip1.png

This example will retrieve all patients who last visited between 01/01/2019 and 31/12/2020.

 

Last Exam, Scale and Clean

Last Exam S+c: The last time one of the S/C items were entered in the Treatment tab. 

Set Scale and Clean Items for Manual Recalls

Set Scale and Clean Items for Automated Recalls

mceclip3.png

This example will retrieve all patients who last had a scale and clean between 01/01/2019 and 01/01/2020. This could be a different date to the Last Visit Date.

 

Patients with E-mail Address

The Value NULL is equivalent to a blank field. Therefore writing NULL means there is nothing entered in the E-mail field.
mceclip4.png

This example will retrieve all patients who DO NOT have an empty e-mail address, therefore have an e-mail address.

The same logic can be used when retrieving all patients with a mobile phone number.

 

Females Over the Age of 18

The Gender and Age of a patient can be found in Patient Records > Patients tab. 

mceclip2.png

mceclip5.png

This example will retrieve all female patients who are 18 years of age or older.

 

Interested in Whitening

Questions like this can be added using the Custom Patient Fields feature.

In this example, the Interested in Whitening? field is a check box.
mceclip6.png

mceclip7.png

If the Interested in Whitening? check box is not ticked, it is considered NULL. Therefore this example will retrieve all patients where this check box is ticked.

 

Patients with a Specific Insurance Fund who have Last Visit

Enter the Insurance Fund Code (in parenthesis), not the full name of the Insurance Fund.

mceclip1.png

mceclip9.png

This example will retrieve all patients who have the specified health fund (Bupa) and last visited between 01/01/2019 and 31/12/2020

mceclip1.png

This example will retrieve all patients who have either one of the specified health funds (Bupa or HCF) and last visited between 01/01/2019 and 31/12/2020

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.