The Advanced Search allows a more specific search for values of certain database fields, called specific field search. Details of each search type are described in the sections listed below.
Specific fields are listed to define the desired result for a search. They represent database fields in the application and can be configured to appear as
When a value is selected the field is combined with other fields and the full text search field to produce the search result
The fields allow more than one object to be selected by pressing the CTRL key. If more than one value is specified, at least one of the selected search criteria must be met for the final search result (compare OR operator in full text search field).
When a value is selected the field is combined with other fields and the full text search field to produce the search result.
Note: To deselect a value, use CTRL key and click on the selected entry.
Allows searching of a result within a certain range (mostly date or numeric fields provide range search) by specifying a lower ("From" field part) and upper bound ("To" field part) for the search value. The search value itself is included in the result (i.e. >= or <=s earch).
If no lower bound is specified, all values up to the upper bound are considered.
If no upper bound is specified, all values starting at the lower bound are considered.
The search result will meet all search criteria for all fields where at least one search value is specified.