Navigation:  WebOffice Standard Reference > WebOffice Category > Layer Queries > Query > Search Results >

Result Field List

Previous pageReturn to chapter overviewNext page

The Result field list specifies all fields to be displayed in the Search Result.

 

Result field list configuration

Result field list configuration

 

Property

Description

Sort order

Specifies sort order:

Ascending or

Descending.

Object name concatenator

Concatenate string for generating the object name.

If e.g. Fields NAME (value Graz) and CATEGORY (value Airport) are concatenated, the resulting object name will be ‘Graz, Airport’.

Note: This parameter will also provide the concatenator for full-text search suggestions and full-text search multilayer results if the parameter "Separator for suggestions?" is set to "Yes" in the attribute Full-Text Search of the application configuration.

In such a case the object name concatenator of the first result field list of the first search result on the respective layer of the first relevant project will be relevant.

Note: Every time the configured concatenator is changed, the existing subindex is "out of date" and has to be recreated.

Show all fields?

If set to Yes, then all Fields of the Layer / Table get displayed, no matter whether they are explicitly configured as Result field or not.

Result field list configuration

 

Result Field

 

For each Result field a set of properties can be configured:

 

Result field configuration

Result field configuration

 

 

Property

Description

Alias name in result

Field of Layer /Table to be displayed in the Search result.

Result page

Alias name to be displayed.

Note: It is recommended to use either Geodatabase Alias or ArcMap Alias definitions instead If possible.

Show field?

Display the field value in the Search result?

Sorting

Sorting according to database field type (fieldtype) or alphanumeric (for TEXT fields only, especially useful for house and parcel numbers and other alphanumeric values).

Sort order/object name

Specifies the Sort order. Use

1 for the first field,

2 for the second field

etc.

None means not to use this field for sorting at all.

Note: This function is used as well to create an object name for this layer by concatenating the field value with Sort order 1 to that with Sort order 2 etc. See Table Result Field List Configuration for more information on object names and concatenation delimiters.

Column size

Column size in Search result.

Note: Being able to explicitly specify the column size in the Result page is useful for providing better layout control (especially for TEXT fields with big field sizes)

Field type

Provide field type information.

Only used when doing search on relational database tables.

Tip: Configure this attribute only if WebOffice is not able to automatically retrieve field type information from the database.

Call Protocol

Makes possible a call to a URL by clicking on the result cell. WebOffice formats the value, provided it is valid (if 'email' is configured, then the value must be an E-Mail Address).

Note: You can choose between 'email' and 'phone'. The attribute 'email' lets the value of the result appear in form of an 'email-link', 'phone' in form of a 'phone-link'. With these links it is possible to activate either a phone call or an email directly from the search result.

Result field configuration

 

Call protocol 'email' and 'phone' in the search result

Call protocol 'email' and 'phone' in the search result

 

Lookup

 

It is possible to configure a Lookup element for each Result field.

Lookup configuration for Result field

Lookup configuration for Result field

 

Lookup in Search result - Country name (CNTRY_NAME) is displayed instead of county code (FIPS_CNTRY) in WebOffice 10 R3 client

Lookup in Search result - Country name (CNTRY_NAME) is displayed instead of county code (FIPS_CNTRY) in WebOffice 10 R3 client

 

See paragraph ‘Lookup’ in chapter Query for more details.

 

See chapters Database Connection and Tables for more details on Table and Database connection configuration.