Show / Hide Table of Contents

Class DBC.FreeTextIndexFields

Fields for FreeTextIndex, This is the index table for the free text search function. Each word in FreeTextWords can have multiple occurrences in this table. Each record in this table points to one occurrence of the word, and points to both the table in which the word occurs (which might be contact or text), and also a pointer to the owner table (which is one of contact, person, project, appointment or sale).

Inheritance
Object
DBC.FreeTextIndexFields
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
public static class FreeTextIndexFields : Object

Fields

ContactId

FreeTextIndex.ContactId: Set for contacts and person records to allow cross-table free-text searches. 0 for non-contact, non-person

Declaration
public const string ContactId = "contact_id"
Field Value
Type Description
String

FreetextindexId

FreeTextIndex.FreetextindexId: Primary key

Declaration
public const string FreetextindexId = "freetextindex_id"
Field Value
Type Description
String

FreetextwordsId

FreeTextIndex.FreetextwordsId: Reference to word

Declaration
public const string FreetextwordsId = "freetextwords_id"
Field Value
Type Description
String

Infile

FreeTextIndex.Infile: Word found in file (0=word found in database)

Declaration
public const string Infile = "infile"
Field Value
Type Description
String

OwnerrecordId

FreeTextIndex.OwnerrecordId: Logical source record. The contact, project, sale that the source belongs to.

Declaration
public const string OwnerrecordId = "ownerrecord_id"
Field Value
Type Description
String

OwnertableId

FreeTextIndex.OwnertableId: Logical source table (high-level), like contact or project

Declaration
public const string OwnertableId = "ownertable_id"
Field Value
Type Description
String

RecordId

FreeTextIndex.RecordId: Source record - the row that contains the word. Might be contact record, or an address or phone

Declaration
public const string RecordId = "record_id"
Field Value
Type Description
String

TableId

FreeTextIndex.TableId: Source table number - could be main (contact, person, etc) or sub-tables like address, email

Declaration
public const string TableId = "table_id"
Field Value
Type Description
String
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top