Navigation:  WebOffice author standalone > Project Wizards Menu > Wizards >

Set queries

Previous pageReturn to chapter overviewNext page

This wizard helps you set up all WebOffice 10.8 SP2 queries (MapService queries, FeatureService queries, WFS queries, and JDBC table queries).

 

woas_searchwizard1

"Set queries" wizard in the %WEBAUTHOR_STANDALONE& menu

 

For a quick overview on configuring a basic hierarchical query in WebOffice 10.8 SP2 see the following video tutorial:

 

Set Query Wizard

 

The first step is to define the service for which the queries are to be configured. The service type can also be filtered here.

 

woas_searchwizard2

Selection of the service for which a query is to be configured.

 

Depending on the service type, you can specify in step 2 whether layer searches or table queries are to be configured.

 

woas_searchwizard3

Determining the type of query

 

The next step is to configure the queries yourself. The individual layers of the service are listed for this purpose, whereby separate queries can be configured for each layer by clicking on Set queries.

 

woas_searchwizard4

Specifying queries

 

By clicking on Set queries, a separate mask opens for the search configuration of the respective layer. Here you can create a new search with Add new search or select and edit an existing search with Select an existing query.

 

 

Add new queries

Add new queries

 

You can define a name for the query and a category under 1).

2) deals with the query logic, which can contain several conditions for the search. Each condition contains a query field for which the condition type (= or LIKE), the type of query field, the type of relationship, a hierarchy level, the obligation, the sort mode, and an alias can be specified. You can use "New condition" to add further query conditions.

 

Under 3) you can assign an existing query result to the query or create a new query result for the query. To do this, select the fields to be displayed in the query result ("Show field?"). For each field you can assign an alias name, sort order and sort mode.

 

woas_searchwizard6

Specifying a new query

 

After the settings are checked again in step 4, the changes can be completed with Finish.