Create ArcGIS query

In order to use the wizard to create an ArcGIS query, you have to open a project configuration.

Go through the chapter to find detailed information for every step of the wizard.

 

See also the following video tutorial for WebOffice author standalone on this topic:

Set Query Wizard

 

See also the following video tutorial for WebOffice author (ArcMap Extension) on this topic:

WebOffice author: Create a query in one minute 

 

Start the Wizard:

 

Starting the wizard "Create ArcGIS query"

Starting the wizard "Create ArcGIS query"

 

Step 1: Map Service

Select the map service to be used for creating an ArcGIS query. Select an already existing ArcGIS Server account and click the button Get services in order to see all available map services. Then choose the respective map service.

 

 

Wizard "Create layer query" - map service

Wizard "Create layer query" - map service

 

Step 2: Layer

After selecting a valid map service the list of layer/tables will contain all layers/tables of this layer/table.

The name of the ArcMap layer or ArcGIS table will be used as the name of the generic query by default. Change the name if you want to configure more than one query on a single ArcMap layer or ArcGIS table.

 

Wizard "Create ArcGIS query" - select layer

Wizard "Create ArcGIS query" - select layer

 

Step 3: Predefined Query

The name of the ArcMap layer or ArcGIS table will also be used as the name of the predefined query by default. Change the name if you want to configure more than one query on a single ArcMap layer or ArcGIS table.

 

Wizard "Create ArcGIS query" - create predefined query

Wizard "Create ArcGIS query" - create predefined query

 

In the query condition dialog choose a field of the ArcMap layer or the ArcGIS table that shall be used for the query and define a condition. The availability of condition operators is based on the field type, e.g. the between operator can only be selected with numeric fields.

Define the search field type:

Text input box: In the WebOffice 10.9 SP1 a text input field will be available.

Value list: In the WebOffice 10.9 SP1 client a value list will be available.

 

icon_comment

Use value lists for field that contain less than 1000 values.

 

Value list with auto complete: In the WebOffice 10.9 SP1 client there will be a text input field available which also provides suggestions. As soon as the user enters the first two letters of the search term, all possible search values will be displayed.

 

icon_comment

Use value lists with auto complete if the field contains more than 1000 values or if the number of values is unknown.

 

Choose the logical operator if you want to use OR. By default the logical operator AND will be used.

Hierarchical queries defines dependencies between search fields. Configure a hierarchical level only if you want to create a hierarchical query.

 

icon_comment

Use a hierarchical query with layer that contain various categories (top level, sub levels). For example:

• Address search with

1. level postal code

2. level street name

3. level street number

• Parcel Search with

1. level municipality cadaster

2. level parcel number

etc.

 

In case you want to configure a search field to be mandatory, check the box in the according field Mandatory search field?.

 

Add the ArcGIS query to an existing search category or create a new one by clicking the button New search category.

 

Wizard "Create ArcGIS query" - create a new search category

Wizard "Create ArcGIS query" - create a new search category

 

Click Next condition if you want to add another field to your query.

 

Otherwise click Next in order to proceed to next step.

 

Step 4: Result Fields

After creating the search fields and conditions, now the result fields and their representation have to be defined.

Change the result name if you do not like the default name (ArcMap layer name or ArcGIS table name).

 

Wizard "Create ArcGIS query" - select result fields

Wizard "Create ArcGIS query" - select result fields

 

In case you want to display all fields besides one or two, uncheck the unwanted fields in the column Show field?.

Otherwise if you want to display one or two fields only you can first click No Fields and then select the desired fields again.

 

Optionally define alias names for your result fields in the column Alias name in result (by default the field name of the layer/table resp. the ArcMap alias name).

In the column Sort order/object name it is possible to define the way how attributes will be sorted in the search result. Select up to 5 fields to be sorted (Start with 1 (top priority), then 2 and so on). The value defines that the field will not be used for sorting at all.

 

icon_comment

The order of the column Sort order/object names also defines the object name in the result view when selecting on more than one layer. The displayed name of the object will be created by merging the sorted fields. The field with the value 1 will be the first part of the object name. Example: Assuming, Address data contains the field STREET with sort order 1 and a field STREET_NR with sort order 2, then an object with STREET = Oxford Street AND STREET_NR = 10 will be displayed as Oxford Street 10.

 

If the sorting mode is set to fieldtype then the sorting will be done according to the field values. Select alphanumeric to achieve an alphanumeric sorting with fields of data type string that also contain some numeric information, e.g. parcel numbers or street names with numbers.

 

Click Next.

 

Step 5: Finish

WebOffice author shows a summary of the query that will be created.

 

Wizard "Create ArcGIS query" - summary

Wizard "Create ArcGIS query" - summary

 

Click Finish to save the ArcGIS query.