Understanding Simple Query Filters

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 uses 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 filters:

And	Returns all records where all arguments are met
Or	Returns all records where either arguments are met

 

Simple Query Examples

Last Visit

A patients' Last Visit is the last date treatment was entered in the Treatment page.

Non-Reporting and Non-Treatment items are excluded.

Last Exam, Scale and Clean

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

Set Scale and Clean Items for Manual Recalls

Set Scale and Clean Items for Automated Recalls

No 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. 

Females Over the Age of 18

The Gender and Age of a patient can be found in Patients > Patients page. 

Interested in Cosmetic work

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

 Specific Insurance Fund

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