Find records within the database

The “Find” function allows you to locate single records or a set of records within the database.

Note that when you are “Find” mode the fields are indicated by a magnifying glass.

Find

You can perform Find requests based on any field in the database. Simply enter the information into the field, and press “Enter”.

For example:

To locate a set of incident records associated with a particular activity:

  1.  Go to “Incidents”
  2. Select “Find”.
  3. Select the desired activity from the field “Activity associated with incident”, and press “Enter.
  4. Select “Table view” to view the set of records

To locate a particular Staff record:

  1.  Go to “Staff”
  2. Select “Find”
  3. Enter the persons’ first or last name, and press “Enter.

To locate a particular Client record:

  1.  Go to “Client”
  2. Select “Find”
  3. Enter the persons’ first or last name, and press “Enter.

To locate all incidents in a particular year, e.g. 2012

  1.  Go to “Incidents”
  2. Select “Find”
  3. In the Date of incident field, type: 2012, and press “Enter.

To locate all incidents within a month, e.g. 12/2012

  1.  Go to “Incidents”
  2. Select “Find”
  3. In the Date of incident field, type: 12/2012, and press “Enter.

To locate all incidents within a date range, e.g. 01/07/2012 – 30/06/2013

  1.  Go to “Incidents”
  2. Select “Find”
  3. In the Date of incident field, type: 1/7/2012 .. 30/6/2013, and press “Enter.

Special characters

There are special characters which can be used in Find requests: @, *, #, ?, !, =, <, >

For example, In Find mode, if we enter:

a)    A staff member’s last name as: *mes

This will find all staff members whose last name ends in “mes”

b)    A participant’s age as: <18

This will find all participants younger than 18

For more information on special characters, please see:

 

%d bloggers like this: