Comparison Elements
The following comparison elements are available for predefined queries:
•BETWEEN
•LIKE
•Equals
•Greater Than
•Smaller Than
All elements have several properties in common which are described below.
Comparison elements configuration
Property |
Description |
||
|---|---|---|---|
Mandatory search field? |
Specifies whether this field is a mandatory search field (no search possible without user input value) (Yes) or not (No). |
||
Hierarchical level |
Specifies the hierarchical level of the search field. •1..top level, •2..next level •etc.
|
||
Negate comparative operator? |
This configuration attribute negates comparisons and conditions as follows: •Condition: The result of a condition will be negated (means anything except ...) •BETWEEN Comparison: between becomes to not between •LIKE Comparison: like becomes to not like •Equals Comparison: equal [=] becomes to unequal [<>]. •Greater Than Comparison: greater than [>] becomes to not smaller than (means greater or equal [>=]) •Smaller Than Comparison: smaller than [<] becomes to not greater than (means less or equal [<=]) |
||
Search field |
Reference to the layer/table field to be searched on. |
Comparison elements properties
If more than one comparison element is configured without a condition, WebOffice 10.9 R4 will automatically handle the comparison elements as if there would be an AND condition. See below some characteristics of certain comparison elements.
BETWEEN Comparison
Concerning the BETWEEN operator, WebOffice 10.9 R4 supports its use for
•numerical field types (integer, long, float, double) as well as
•date field type
This way users can search on, e.g. objects that have been changed between 1st of January 2000 and 31st of December 2010.
LIKE Comparison
The LIKE operator includes one additional property.
LIKE comparison configuration
Property |
Description |
|---|---|
LIKE search option |
Specifies how the LIKE search is performed: •Search for field values, which start with the searched term or expression (starts with; equals or corresponds the search of xxx*) •Search for field values, which contain the searched therm or expression (contains; equals or corresponds the search of *xxx*). (where xxx is the search form and the wild card * (placeholder) equivalent). •To find similar - sounding field values (phonetic) |
LIKE comparison properties
Equals Comparison
The Equals operator includes the same types of LIKE comparisons. To define the = LIKE comparison, the search options (starts with, contains, phonetic) are selectable from the value list with auto-complete.
Configuration of the LIKE-search option using the equals comparison
Greater/Smaller Than Comparison
Use this operators to provide queries with a greater or smaller than comparison
|
•Find details regarding the available input control types in chapter Input Control Types. •See chapter Condition for more information about conditions. •See chapter Queries for details about queries in the WebOffice core client. |
