WebOffice author > Edit Menu > WebOffice Category > Layer Queries > Query > List of Predefined Queries > Query

The following comparison elements are available for predefined queries:

•

BETWEEN

•

Equals

•	Greater Than

•	Smaller Than

All elements have several properties in common which are described below.

Comparison elements configuration

Property

Description

Search field

Reference to the layer/table field to be searched on.

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.

Note: 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 [<=])

Comparison elements properties

If more than one comparison element is configured without a condition, WebOffice 10.2 SP3 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.2 SP3 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

Note: Find details regarding the available input control types in chapter Input Control Types.

Note: See chapter Condition for more information about conditions.

Note: See chapter Queries for details about queries in the WebOffice flex client.

Comparison Elements