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.

Back