|
|
You can search on any of the database fields using these filters. |
|
|
|
|
|
Tip If you want to move a query from the top box to the bottom box or vice-versa, drag it with the mouse and drop it into the other box. |
|
|
|
|
|
Data must match ALL of these statements |
|
|
In order for a record to pass successfully through the filter it must match ALL of the criteria in this section. If it matches two out of three, for example, it will not pass through.
For example: You would set filters in this section if you wanted to find all the Doctors living in Birmingham. To do this you would have a filter set for Job title is equal to Doctor and Town is equal to Birmingham.
In this example both criteria must match for the record to pass through the filter. |
|
|
|
|
|
Data must match at least ONE of these statements |
|
|
In order for a record to pass successfully through the filter it must match AT LEAST ONE of the criteria in this section. If it matches two out of three, for example, it will pass through.
For example: You would set filters in this section if you wanted to find all Doctors, Nurses and Surgeons. Your filters would be Job title is equal to Doctor or Job title is equal to Nurse or Job title is equal to Surgeon. |
|
|
|
|
|
Why doesn't anything pass through my filter? |
|
|
This is usually due to conflicting requests in the top AND box.
For example, if you want to find all the doctors and nurses you would use the bottom OR box because you want the Job title to be Doctor OR Nurse. If you use the top AND box you are effectively asking for the Job title to be both Doctor and Nurse, and it can never be both. (A person's job title can be either Doctor or Nurse but never both).
To find all Doctors and Nurses in Birmingham you would:
In the top AND box set a filter to be Town is equal to Birmingham
In the bottom OR box set a filter to be Job title is equal to Doctor
In the bottom OR box set a filter to be Job title is equal to Nurse
Of course, the filter has its limits. For example, you can't find all the Doctors and Nurses in Birmingham and Leeds, because the Town filter would have to be in the OR box along with the Job title filter, and you would end up with everyone who was a Doctor or Nurse, plus everyone who lived in Birmingham or Leeds (because only ONE of the criteria needs to match in order for the record to pass through). To do complex filters like this you must create a Virtual Folder at the end of the Wizard and then use that Virtual Folder as the source on the second pass of your filter. |