Search Tab
All of Optisoft’s data is stored in tables relating to a specific element, the Patients table, for example, contains the patient data. These tables are broken down into fields, for example the FirstNames, Surname and Date of Birth fields.
Example 1
In this example we will create a set of criteria that will find all of the patients with the surname of Smith.
- Select the Patients table in the table box
<<IMAGE HERE>>
- Select the Surname field in the fields box
<<IMAGE HERE>>
- This will open the Enter Search Value dialogue
<<IMAGE HERE>>
- Enter Smith into the Search For box
- Click OK to add the criteria to the search list on the right side of the screen.
<<IMAGE HERE>>
Example 2
In this example we will create a set of criteria that will locate all of the patients on the database who are over 60 and have a prescription of +4 sphere or higher.
- Select the Patients table in the table box
- Select the Date of Birth field in the fields box
- Double click on the < (less than) in the criteria box
- This will open the Enter Search Value dialogue
<<IMAGE HERE>>
- Enter 01/01/1947 in the search box. This will provide the results for all patients whose date of birth was before 01/01/1947.
- Click OK to add the criteria to the search list.
- Now select the Patients Rxs table in the table box
<<IMAGE HERE>>
- Select the R Sphere field in the Fields list
- Double click on the >= (greater than or equals to) in the criteria box
<<IMAGE HERE>
- Enter 4 into the Enter Search Value dialogue and click OK.
These criteria will provide us with a list of all patients over 60 with a right sphere measurement of +4 or higher, but patients have two eyes so the criteria are not complete. We will need to use the OR statement to combine 2 separate queries.
<<IMAGE HERE>>
- Click on the OR radio button
- Select the Patients table in the table box again
- Select the Date of Birth field in the fields box
- Double click on the < (less than) in the criteria box
- Enter 01/01/1947 in the Enter Search Value dialogue and click OK.
- Click on the AND radio button to change the Combine Using method again.
- Select the Patients Rxs table in the table box
- Select the L Sphere field in the Fields list
- Double click on the >= (greater than or equals to) in the criteria box
- Enter 4 into the Enter Search Value dialogue and click OK.
<<IMAGE HERE>>
- We now have a set of criteria that will find patients over 60 with a right sphere of +4 or higher OR patients over 60 with a left sphere of +4 or higher.
It is important to note that the OR method effectively draws a line under the previous set of criteria and starts a fresh query whose results are then added to those of the previous part.