This chapter describes the query builder functionality in the WebOffice core client. With the query builder for a generic search, the user may define queries with individual parameters. Start the query builder by clicking the button Start Querybuilder in the Queries ribbon menu.

 

Note: The button will be inactive as long as the query builder was not enabled on the respective query layer. See chapter Query for details about the configuration in WebOffice author standalone.

 

Generic search using the query builder in the WebOffice core client

Generic search using the query builder in the WebOffice core client

 

First choose a Field and define an Operator, then enter a value. By clicking the green + button, another condition can be added. Activate the option Search in current map extent only to limit the search results for the current extent.

 

Usually, a value list with auto complete will be displayed as input field. It is also possible to show a big value list by clicking the symbol next to the input field.

 

Big value list when using the query builder

Big value list when using the query builder

 

In order to execute a search click the Search button. Choose from the following search types:

•New Result with map update (Zoom): WebOffice 10.9 R4 shows the found objects in the search result, zooms to them and selects them in the map.

•New Result with map update (Pan): WebOffice 10.9 R4 shows the found objects in the search result, pans to them without changing scale and selects them in the map.

•New Result: WebOffice 10.9 R4 shows the found objects in the search result without selecting the objects in the map.

•New Result with map update (filter): WebOffice 10.9 R4 uses a filtering search that will be accessible in the stack menu under Layer Filter. This option will be available only if the parameter Filtering Search is activated for the respective layer.

 

Select one out of four search types in the query builder of the WebOffice core client

Select one out of four search types in the query builder of the WebOffice core client

Multiple search criteria can be searched using the separator *;* (semicolon).

Multi search criteria in the WebOffice core client

Multi search criteria in the WebOffice core client

 

The user can make his query available in another session by saving it with the button Save query as. It will then be accessible in the list of Queries.

Note: See chapter Common Settings for the configuration in WebOffice author standalone.

Note: If WebOffice usermanagement is activated then Userdefined queries will be available only for user that saved the query.

Note: Userdefined queries will be saved in WEB-INF Directory.

 

Saved user defined query in the WebOffice core client

Saved user defined query in the WebOffice core client

 

In another session the user can delete any userdefined queries by selecting it from the list of queries. In the query builder itself there is an additional button

 

Delete a user defined query in the WebOffice html client

Delete a user defined query in the WebOffice html client

 

Note: Any search fields have to be indexed (database index)

Note: Queries that are generated with the query builder can be more extensive then queries from the WebOffice 10.9 R4 project configuration. Both brackets can be set and the operators is NULL and is not NULL can be used to check data consistency.

Note: See chapter Query for details about the configuration of the query builder and filtering search in WebOffice author standalone.

Note: See chapter Common Settings to make userdefined queries storable.

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

Note: See chapter Search Field List for details about the configuration of search fields that can be used in the query builder.

Note: See chapter Generic Search - Value List Behavior for further configuration parameters regarding the query builder.