Query - Where Clause

The Query - Where Clause element contains all parameters specific to predefined queries:

Condition

BETWEEN Comparison

LIKE Comparison

Equals Comparison

Greater Than Comparison

Smaller Than Comparison

Application with Static Hyperlink

 

Besides the sub-elements several settings can be specified.

 

Query - where clause configuration

Query - where clause configuration

 

Property

Description

Name

Name of the predefined query displayed in the WebOffice 10.9 SP1 clients.

Image for search icon

URL of the image used as search icon and for marking the search result list. File extension (e.g. .gif or .jpg) must be included. Image file must have size 24x24 pixels.

Note:

This parameters is WebOffice flex (flash) specific.

First gradient color

First color of the gradient filling the background of the search header.

Notes:

This parameters is WebOffice flex (flash) specific.

The following color values are recommended for the skin navajowhite3:

80,80,80

144,140,137

Project skins can be defined in the Customer Information.

Second gradient color

Second color of the gradient filling the background of the search header.

Notes:

This parameters is WebOffice flex (flash) specific.

The following color values are recommended for the skin navajowhite3":

80,80,80

144,140,137

Project skins can be defined in the Customer Information.

Text color

Text color of the header.

Note:

This parameters is WebOffice flex (flash) specific.

Text hover color

Text color of the header, when hovering over the header.

Note:

This parameters is WebOffice flex (flash) specific.

Default search result

Default search result used for displaying search results.

Search category

Assign the predefined query to a search category defined in the List of Search Categories.

Access control ID

Access control ID needed for access control based on WebOffice usermanagement module.

If an ID is configured here (eg QUERY_OWNER_BY_ADDRESS) and WebOffice usermanagement module is used then the user role is checked whether it provides the necessary application right or not (according to the example the application right would be QUERY_OWNER_BY_ADDRESS). If the necessary application right is not available then the stored query will not be available in WebOffice 10.9 SP1.

Note:

More details to usermanagement based restrictions can be found in WebOffice usermanagement.

Filtering search

Enables (Yes) or disables (No) the filtering search function. With enabled filter search function only objects listed in the search result are displayed.

Notes:

The filter function only works for layers of dynamic map services. Layers from cached map services cannot be filtered, because they are already calculated for the tiles.

See chapter Queries and Layer Filter to see how filtering search works in the WebOffice core client.

One-Click Query?

Enables (Yes) or disables (No) the one-click query.

In some cases it is useful to configure a one-click query so users are able to execute a predefined query by one interaction.

Notes:

Note that a default value must be configured for a comparison element.

See chapter Queries for details how a one-click query works in the WebOffice core client.

Merge search fields?

Merge all search fields into a text input box (Yes) or display each search field separately (No).

Notes:

See chapter Connected Address Search for more details on how to configure a useful query with this option.

Using the option Merge search fields indicates that there is no possibility to use a value list with auto complete.

Allow spatial attributive search function?

Enables (Yes) or disables (No) the spatial attributive search function. The search is restricted to the current selected map extent. The function will be available as a checkbox in the query dialog.

Notes:

See chapter Queries for details how this restriction works in the WebOffice core client.

The spatial attributive search function also works together with a one-click query configuration. If this parameter is set to Yes in combination with the one-click query the spatial attributive search function is activated and the one-click query will search in the current spatial extent.

Spatial attributive Search activated per default?

Activates (Yes) or deactivates (No) the spatial attributive search function per default.

Use in clients without search form?

Activates (Yes) or deactivates (No) this search for client which are not capable of displaying multi-field search forms (e.g. the WebOffice mobile client).

Keep results after single hits?

If No (default value) is configured, the search result is closed as soon as the user selects a single result entry.

Submit Search with Enter key?

Activates ('Yes') or deactivates ('No') submitting the search through enter key, when last search field is reached.

Submit search from TOC?

Activates ('Yes') or deactivates ('No') submitting the search through right click of the thema in TOC.

Query - where clause properties

 

Notes:

See chapter Queries for details about queries in the  WebOffice flex (flash) client.

See chapter Queries - Filtering Search for details about the filters in WebOffice flex (flash) client.