You can access Where searches in the Stockitem and Borrower modules by selecting Application > Where... (in the Stockitem module) or Application > BorrowerWhere (in the Borrower module)
operator | description | example |
---|---|---|
LIKE | Where the required data in this field begins with the text entered | LIKE ELD (for Eldorado) |
Where the required data in this field does not begin with the text entered | ||
IN | Useful for selecting multiple codes | IN A,J,YA (for all of these types) |
Useful for multiple codes not to be included | ||
= | Where the text entered is exactly equal to the data required | = A (borrowers with a code of A for Adult) |
≠ | Where the text entered is not equal to the data required Useful for NOT EQUAL TO NULL – choose this operator, do not enter any data and click the Paste button |
≠ J (borrowers who do not have a code of J) |
< | Where the text entered is less than the data required | < 01/10/10 (less than 1 Oct 2010) |
≤ | Where the text entered is equal or less than the data required | ≤ 01/10/10 (less than or equal to 1 Oct 2010) |
> | Greater than | >01/10/10 (greater than 1 Oct 2010) |
≥ | Equal or greater than the text entered | ≥ 01/10/10 (greater than or equal to 1 Oct 2010) |
button | description |
---|---|
Paste | Adds the Where condition to the Query Description table |
Special | This button contains useful fields that can be used for any mathematical operand (i.e. =, ≠, <, ≤, >, ≥) – for example: Current Date |
Delete | Deletes the highlighted Where condition from the Query Description table |
AND | Includes the AND separator to the Where conditions in the Query Description table (this is the default) |
OR | Includes the OR separator to the Where conditions in the Query Description table |
( | Adds a beginning bracket to the Where condition in the Query Description table |
) | Adds a closing bracket to the Where condition in the Query Description table |
The NULL value is achieved by simply leaving a blank space in the field 3 Type the Where Condition and Press Paste – as soon as the Paste button is clicked a NULL value is entered into the Query Description table.
It is possible to save a Where search:
It is possible to save the Where search results to a file, which can then be used in other operations (including reports).