Full-text search status fields

The configured status fields 'UniqueID' and 'ChangeDate' enable WebOffice 10.8 SP2 to detect changes by third party applications to indexed data. Affected subindices can subsequently be re-created when required.

If a different field than the OID-Field (typically: 'OBJECTID') is configured, a subindex may persist without re-creation when data is exported and re-imported.

In addition, if features are changed by a third system, the subindex is "out of date", although the number of features in the subindex does match the current number of features of the layer.

Note: See chapter Full-text search (synadmin) for details about the status "out of date".

Therefore the status fields "UniqueID" and "ChangeDate" have to be configured.

Full-text search status fields configuration

Property

Description

UniqueID field

Field containing unique values that should be used instead of the default OID field (typically: 'OBJECTID') to identify a specific record.

Note: The field 'UniqueID' must contain unique values

Note: The values can be set manually or generated automatically (see data type GLOBALID).

Note: The following data types are allowed: GLOBALID, GUID, OID, SINGLE, DOUBLE, INTEGER, SMALL_INTEGER, DATE, STRING.

ChangeDate field

Field containing a timestamp (in the UTC time zone) of the last data change that indicates whether a record must be updated in the index.

Note: The field 'ChangeDate' must contain a timestamp of the last data change of the corresponding record

Note: The value of this field must be updated (manually or automatically through a database-trigger) whenever the value of a field (except: OBJECTID) of this record is changed.

Properties - Status fields

After configuring full-text search status fields the subindex has to be calculated. This can be found in SynAdmin in the full-text search tab under the name of the "External Layer-ID".

The details for the subindex include (amongst others) the status fields, where the configured UniqueID field and ChangeDate field are visible.

Full-text search status fields subindex

Note: The full-text search web application has to be installed in order to provide full-text search functionality. Make sure you have read the chapter WebOffice FTS-Index and installed the required components.

Note: See chapter Full-Text Search for details about the full-text search configuration in the application configuration.

Note: See chapter Full-Text Search for details about the full-text search configuration in the project configuration.

Note: See chapter Full-Text Search Tab for details about the full-text search tab in SynAdmin.

Note: See chapter Quicksearch for details about the full-text search in the WebOffice html client.

Note: See chapter Quicksearch for details about the full-text search in the WebOffice flex (flash) client.

Note: When encountering problems related to the full-text search, follow the troubleshooting described in chapter Problems Related to Full-Text Search.