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

mceclip1.png

 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.

mceclip0.png

mceclip1.png

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

mceclip0.png

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. 
mceclip1.png

Females Over the Age of 18

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

mceclip3.png

mceclip2.png

Interested in Cosmetic work

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

mceclip4.png

 Specific Insurance Fund

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

mceclip6.png

mceclip5.png

 

 

 

 

 

0 out of 0 found this helpful

Comments

0 comments

Article is closed for comments.