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:
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:
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.
This example will retrieve all patients who last visited between 01/04/2024 and 30/04/2024.
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
This example will retrieve all patients who last had a scale and clean between 01/01/2024 and 01/01/2025. 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.
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.
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 improving smile? field is a check box.
If the Interested in improving smile? 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.
This example will retrieve all patients who have the specified health fund (Bupa) and last visited between 01/01/2024 and 31/12/2024
This example will retrieve all patients who have either one of the specified health funds (Bupa or HCF) and last visited between 01/01/2024 and 31/12/2024
Comments
Article is closed for comments.