The Search Field List specifies all search fields available

for predefined queries

in the query builder form

 

The definable parameters has impact only on the query builder, since with predefined queries search fields are not selectable for the user.

 

Search field list configuration

Search field list configuration

 

Property

Description

Sort order

Specifies the overall Sort order:

ascending

descending

Search field list properties

 

icon_comment

The context menu of the Search Field List includes the possibility to automatically import all search fields to the current project configuration (Import fields from service). The search fields will be imported based on the corresponding service.

 

Automatic import of search fiels of the service

Automatic import of search fiels of the service

 

Search Field

Add various Search Fields via right-mouse context menu.

 

icon_comment

If a field has an attributive index in the database, the field is marked with *.

 

Search field configuration

Search field configuration

 

Property

Description

Alias

Name (alias) to be used for the search field in the WebOffice 10.9 R3 clients.

icon_cross-reference

It is recommended to use either Geodatabase alias or ArcMap alias definitions instead If possible. See chapter Field Alias for details about best practices regarding alias names.

Field

Search field. Either a layer field or a table field is referenced.

icon_comment

Define in the Basic Settings whether you want have alias or technical names displayed in the drop-down list.

If a join is made to the layer in the ArcGIS map document (ArcMap or ArcGIS Pro), the technical field name will change from fieldname to featureclass.fieldname. If a WebOffice configuration has been created on this layer before, it is as designed in this case that in the WebOffice author standalone the search and result field configuration has to be reconfigured.

Sorting

Sorting is either done

according to the database field type (fieldtype) or

by means of a specific WebOffice sorting algorithm (for TEXT fields only, especially useful for house or parcel numbers and other alphanumerical values) when using configuration value alphanumeric.

Do case insensitive search?

Perform a case insensitive search (Yes) or not (No).

If search performance is poor this may be due to case insensitive search mode. Try No then.

icon_comment

Querying a table of an Oracle DB case insensitive will disable the attribute index of the table, leading to a performance decrease.

A query on a search field (type String) from an Oracle DB only works with indexing if

othe query is executed case insensitive (do case insensitive search - No) and

othe Oracle Index is a functional index on upper case letters (function based index on UPPER function).

Case insensitive search on feature classes with Joins in Oracle DBs using NLS_UPPER will only work, if:

oThe option ‘keep only matching records’ is set on the ArcMap Join

oThe source table (feature class) and target table (Join table) are from the same data source

If these preconditions are not reached, the Join operation will not work.

For external Calls only?

Defines whether the search field may only be used for external parametrized calls. If activated, the field is neglected for the query builder and the full-text search.

icon_comment

If all defined search fields are defined for external calls only, then the query builder cannot be opened. A warning message will say The query is not available (no valid search fields).

icon_cross-reference

It is possible to check in SynAdmin which search fields are indexed for the full-text search. See the HowTo chapter Full-Text Search for details.

Search field properties