Database structure (SQL FTS)

Build 1501 on 14/Nov/2017  This topic last edited on: 5/Aug/2014, at 14:54

The main object table 's_ObjectTable' has a new built-in column 'gn_FullText' that contains the complete text that should be full-text indexed by the SQL server for each object.

When the current full-text engine is 'Sql' this column is filled automatically every time a full-text searchable object is created or modified.

The 'gn_FullText' column is always null when the current full-text engine is Exalead or 'None' = no full-text searches.

Please upgrade you database to get SQL full-text working (it is enough to upgrade it once, after upgrading to GN4 version 2.0).

srv4 dbupdate -s <schema file> -d ""