Conditions

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

Property

Description

Search field

Reference to the Layer / Table field to be searched on.

Mandatory search field?

Specifies, if 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 [<=]).

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, more details, see Chapter phonetic search).

Property

Description

Tooltip

The tool-tip entered in the textbox part of the advanced input list. For example 'Enter street name').

Note: When the user is points onto a advanced-list-box in the query form, the available information will be displayed as a tool tip.

Minimum user input length

Specifies the necessary count of characters typed in by the user, before the list box will be populated automatically with the values in WebOffice.

Waiting time [ms]

Time to wait before the WebOffice 10 R3 request is submitted [ms].

LIKE - search option

Defines how the list of selectable values in the search form is determined

•Predefined selective values, which start with the search therm ('starts with'; equals or corresponds to the following SQL-query condition: LIKE 'expression*'),

•Predefined selective values, which include ('contains'; equals or corresponds the following SQL-query condition: LIKE '*expression*').

•Find similar of similar-sounding field values (phonetic, more details, see Chapter phonetic search).

Count of suggestions

Specifies the count of values returned by WebOffice 10 R3 (also when when more values are available in the dataset). The function is solely build for more comfort. The user obtains thus a small, neatly arranges list to work with.

The sorting is carried on in such a way, that the values with the search-expression/condition are arranged before those values, in which the search expression/condition includes the actual queried/searched expression.

The use of this option is recommended for WebOffice mobile mobile projects but not within a hierarchical search.

Note: WebOffice 10 R3 may NOT display all values but only as many as configured.

Property

Description

Value

Value, which will be automatically displayed in the client search form.

Note: When configuring default values in combination with date fields it is possible to set a variable default date where "0" is the current date. Therefore, e.g. "-30" will show the date 30 days ago and "30" will add 30 days to the current date.

Hide search field?

Hide ('Yes') or show ('No') the search field. The default value is used during the search as if it were a filter.

Property

Description

Application name

Name of external web application used for display in WebOffice client (Search result).

Popup window width

If using popup windows for displaying external contents the size of the popup window can be configured.

Popup window height

If using popup windows for displaying external contents the size of the popup window can be configured.

Buttons available?

Property is not available for static hyperlinks.

Icon for application call

In WebOffice folder pub/images 10 icons are available (extapp_01.gif, extapp_02.gif to extapp_10.gif). Icon size 16x16 pixels.

URL

Full URL pointing to the site to display

Provide user context?

Used for UserManagement secured projects. Specifies if the user context of the user logged on to WebOffice will get passed in the HTTP header.

Note: If providing a user context to an external application the URL will be redirected. All paths used in the external Application have to be absolute!