Query - Where Clause

Property

Description

Name

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

Image 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.

Note: This parameters is WebOffice flex (flash) specific.

Note: 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.

Note: This parameters is WebOffice flex (flash) specific.

Note: 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 SP2.

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.

Note: 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.

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

One-Click Query

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

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

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

Merge search fields?

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

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

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

Permit 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.

Note: See chapter Queries for details how this restriction works in the WebOffice html client.

Note: 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).