thankQ Help
The following table outlines operators that can be used in yellow box searching. They may be used on any text, numeric or date field coloured yellow, after clicking the Search button.
Operator |
Function Explanation |
Example |
|
and |
All conditions must be met. You can use more than two conditions joined with “and” statements. |
Payments tab / Date field |
>=01/07/11 and <=01/07/12 |
or |
Only one of the conditions must be met. |
Table View Tab / Suburb field: Payments tab / Source code field |
Sydney OR North Sydney
MEMBER or 07APSUM |
> |
Greater than – Results will be more than the value input. |
Payments tab / Payment amount field |
>500 |
< |
Less than – Results will be less than the value input. |
Payments tab / Payment amount field |
<200 |
>= |
Greater than or equal to – Results will be greater than or equal to the value input. |
Pledges tab / Total value field |
>=12000 |
<= |
Less than or equal to – Results will be less than or equal to the value input. |
Pledges tab / Total value field |
<=100 |
<> |
Not equal to. |
Profile tab / From field |
<>04/08/2009 |
Is null |
Return records where there is no value in this field. |
Type into the field you want to search on. |
is null |
Is not null |
Return records where there is a value in this field. |
Type into the field you want to search on |
is not null |
