Class FreeTextIndexRecordData
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the freetextindex table.
Namespace: SuperOffice.CRM.Rows
Assembly: SoDataBase.dll
Syntax
public class FreeTextIndexRecordData : ObjectRemarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Constructors
FreeTextIndexRecordData()
POCO (Plain Old CLR Object) class that can be used to hold data corresponding to a row from the freetextindex table.
Declaration
public FreeTextIndexRecordData()Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Fields
ContactId
Set for contacts and person records to allow cross-table free-text searches. 0 for non-contact, non-person
Declaration
public int ContactIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
FreetextindexId
Primary key
Declaration
public int FreetextindexIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
FreetextwordsId
Reference to word
Declaration
public int FreetextwordsIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
Infile
Word found in file (0=word found in database)
Declaration
public short InfileField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
OwnerrecordId
Logical source record. The contact, project, sale that the source belongs to.
Declaration
public int OwnerrecordIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
OwnertableId
Logical source table (high-level), like contact or project
Declaration
public short OwnertableIdField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
RecordId
Source record - the row that contains the word. Might be contact record, or an address or phone
Declaration
public int RecordIdField Value
| Type | Description |
|---|---|
| Int32 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.
TableId
Source table number - could be main (contact, person, etc) or sub-tables like address, email
Declaration
public short TableIdField Value
| Type | Description |
|---|---|
| Int16 |
Remarks
Please use this class instead of a full FreeTextIndexRow object when you do not need to create or update a value in the database. Row objects have a large overhead since they carry the corresponding FreeTextIndexTableInfo object, which in turn defines fields and aliases; there may be a Sentry on a row, and various other helper objects.