Page History
Use the options in this area to specify your selection requirements.
Selected fields
Select the field to which you wish to attach a search condition (i.e. an Operator). Take care when choosing this field, as choosing the right type of field can really affect the performance of your query.
...
| Note |
|---|
| Note: Do not select a virtual field here. If you add a search condition to a virtual field, it will degrade the performance of your query. (The icons of virtual fields are colored blue in the Query window.) |
Operators
Select one of the operators from the drop down list. You can select:
is equal to | is less than |
For Range or Between conditions, combine is greater than or equal to and is less than or equal to
Using AND/OR/Not
You can further refine your search conditions using the AND/OR/Not radio buttons.
...
Quite precise search criteria can be specified by grouping two or more of these conditions together. Refer to 3.7.3 The Conditions Area for an example and details about grouping your conditions.
Value
The value to use with your search condition.
...
For example, if your Value is:
Wils% or Wils* | you will retrieve Wilson, Wilshire, Wilshaw, Wilsmore, etc. |
|---|---|
Wils % or Wils * | you will retrieve Wils John, Wils Duncan. |
Wil_s% or Wil?s* | you will retrieve Wills, Wilesley, Wilms, etc. |
%Wil% or Wil | you will retrieve names which have Wil somewhere in them, such as David Willis, Jo O'Wilket, etc. |
...
LANSA Client will append the % character to the end of the value entered if the field is longer than the value you have entered and if you haven't used a wildcard character.
If the value can vary each time the query is run, for example you want to select sales by date, enter a default value here and specify in the Prompting area that you want to enter a Value when the query is run.
Make condition case sensitive
Ideally, it is better to select alphabetic data which exactly matches the case of the Value you have entered.
...
| Note |
|---|
| Note: Some databases are case-insensitive, and upper and lower case characters are treated as equivalent. For these databases, the case of the Value entered is ignored when retrieving data. For example, if you entered ABC as the Value, with an Operator of 'is like' and with the Make condition case sensitive option selected, you could receive back AbCd, ABCD, abcd and so on. This is normal behavior for case-insensitive selection. Your database administrator will be able to advise you if your host database is of this type. |
Date and Time Entries
To the right of the Value, is a button labelled "...".
...
For more information, refer to DateTime Selection.