Navigation:  WebOffice author > Edit Menu > WebOffice Category > Layer Queries > Query > List of Predefined Queries > Query - Where Clause >

Condition

Previous pageReturn to chapter overviewNext page

A predefined query may contain one or multiple Condition elements. Conditions are logical operators to logically combine one or multiple search fields.

 

Note:

It is not possible in WebOffice 10.4 SP2 to configure nested conditions.

Logical OR operator is only possible on lowest hierarchy level.

It is possible to negate conditions and comparisons with the attribute "Negate comparative operator?".

 

Condition configuration

Condition configuration

 

Property

Description

Logical operator

Use AND for using logical operator Field1 AND Field2 …

Use OR for using logical operator Field1 OR Field2 …

Note: Fields by default get combined using AND, i.e. if you do not need to configure any Condition element if you want to use AND.

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

Condition properties

 

Note: See chapter Comparison Elements for configuration details about the various operator types.

Note: See also Queries for details about queries in the WebOffice html client.