thankQ Help
The following table outlines operators that can be used in conjunction with your yellow box searching. They may be used in text, numeric or date fields that are 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.
|
>=1/1/2012 AND <=5/1/2012 |
or |
Only one of the conditions must be met. |
Suburb field – Sydney OR North Sydney
|
> |
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: <> 4/08/2005 |
Is null |
Return records where there is no value in this field. |
Type is null into the field you want to search on.
|
Is not Null |
Return records where there is a value in this field. |
Type is not null into the field you want to search on.
|
Date range |
From a start date to an end date.
Between a start and end date.
Between Calendar years on Payment tab or Financial Years on Fundraising tab. |
>=1/1/2012 AND <=5/1/2012
>31/12/2011 AND <6/1/2012
>=2011 AND <=2014 |
