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

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.

icon_comment

Configuring the hierarchical level only makes sense if at least two comparison elements with different configured hierarchical level values (starting from value 1) are configured within one predefined query. Combining comparisons using the logical OR operator is only possible on the lowest hierarchical level.

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 SP1 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 SP1 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

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

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

 

icon_cross-reference

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.