Class KbEntryTableInfo

Table 'kb_entry': This table contains FAQ entries.

Inheritance

Object

TableInfo

KbEntryTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("kb_entry")]
public class KbEntryTableInfo : TableInfo, ICloneable

Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table KbEntry in the database dictionary: kb_entry

Declaration

public const string DictionaryTableName = "kb_entry"

Field Value

Type	Description
String

Properties

AccessLevel

Field 'access_level' in table 'kb_entry': Dictionary type Enum, .NET type: Int16

The access level for this entry (enum).

Declaration

public UInt16FieldInfo AccessLevel { get; }

Property Value

Type	Description
UInt16FieldInfo

Answer

Field 'answer' in table 'kb_entry': Dictionary type Clob, .NET type: String

The answer for this entry.

Declaration

public StringFieldInfo Answer { get; }

Property Value

Type	Description
StringFieldInfo

CategoryId

Field 'category_id' in table 'kb_entry': Dictionary type FK, .NET type: Int32

The id of the category in which this entry is located.

Declaration

public Int32FieldInfo CategoryId { get; }

Property Value

Type	Description
Int32FieldInfo

CategoryId_InnerJoin_KbCategory

Generated join from the foreign key CategoryId in this table, to its target table KbCategoryTableInfo.

Declaration

public TargetedInnerJoin<KbCategoryTableInfo> CategoryId_InnerJoin_KbCategory { get; }

Property Value

Type	Description
TargetedInnerJoin<KbCategoryTableInfo>

CreatedBy

Field 'created_by' in table 'kb_entry': Dictionary type FK, .NET type: Int32

The id of the user who owns this entry.

Declaration

public Int32FieldInfo CreatedBy { get; }

Property Value

Type	Description
Int32FieldInfo

CreatedBy_InnerJoin_Ejuser

Generated join from the foreign key CreatedBy in this table, to its target table EjuserTableInfo.

Declaration

public TargetedInnerJoin<EjuserTableInfo> CreatedBy_InnerJoin_Ejuser { get; }

Property Value

Type	Description
TargetedInnerJoin<EjuserTableInfo>

DbiAgentId

Field 'dbi_agent_id' in table 'kb_entry': Dictionary type FK, .NET type: Int32

Integration agent (eJournal)

Declaration

public Int32FieldInfo DbiAgentId { get; }

Property Value

Type	Description
Int32FieldInfo

DbiAgentId_InnerJoin_DbiAgent

Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.

Declaration

public TargetedInnerJoin<DbiAgentTableInfo> DbiAgentId_InnerJoin_DbiAgent { get; }

Property Value

Type	Description
TargetedInnerJoin<DbiAgentTableInfo>

DbiKey

Field 'dbi_key' in table 'kb_entry': Dictionary type String[256], .NET type: String

The primary key for the integrated entry in the external datasource.

Declaration

public StringFieldInfo DbiKey { get; }

Property Value

Type	Description
StringFieldInfo

DbiLastModified

Field 'dbi_last_modified' in table 'kb_entry': Dictionary type DateTime, .NET type: DateTime

When the entry was last modified.

Declaration

public DateTimeFieldInfo DbiLastModified { get; }

Property Value

Type	Description
DateTimeFieldInfo

DbiLastSyncronized

Field 'dbi_last_syncronized' in table 'kb_entry': Dictionary type DateTime, .NET type: DateTime

Last external syncronization.

Declaration

public DateTimeFieldInfo DbiLastSyncronized { get; }

Property Value

Type	Description
DateTimeFieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

DictionaryTableNumber

Table number for table KbEntry in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration

public int DictionaryTableNumber { get; }

Property Value

Type	Description
Int32

ExpireDate

Field 'expire_date' in table 'kb_entry': Dictionary type DateTime, .NET type: DateTime

The date until which this entry is valid.

Declaration

public DateTimeFieldInfo ExpireDate { get; }

Property Value

Type	Description
DateTimeFieldInfo

Flags

Field 'flags' in table 'kb_entry': Dictionary type UInt, .NET type: UInt32

A bitmap field.

Declaration

public FieldInfo Flags { get; }

Property Value

Type	Description
FieldInfo

KbEntryId

Field 'id' in table 'kb_entry': Dictionary type PK, .NET type: Int32

The primary key (auto-incremented)

Declaration

public Int32FieldInfo KbEntryId { get; }

Property Value

Type	Description
Int32FieldInfo

Keywords

Field 'keywords' in table 'kb_entry': Dictionary type String[256], .NET type: String

The keywords for this entry

Declaration

public StringFieldInfo Keywords { get; }

Property Value

Type	Description
StringFieldInfo

LastChanged

Field 'last_changed' in table 'kb_entry': Dictionary type DateTime, .NET type: DateTime

When the entry was last changed.

Declaration

public DateTimeFieldInfo LastChanged { get; }

Property Value

Type	Description
DateTimeFieldInfo

LeftOuterJoin_KbAttachment_EntryId

Generated left outer join from the primary key KbEntryId on this table, to KbAttachment.EntryId.

Declaration

public TargetedLeftOuterJoin<KbAttachmentTableInfo> LeftOuterJoin_KbAttachment_EntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbAttachmentTableInfo>

LeftOuterJoin_KbEntryComment_KbEntryId

Generated left outer join from the primary key KbEntryId on this table, to KbEntryComment.KbEntryId.

Declaration

public TargetedLeftOuterJoin<KbEntryCommentTableInfo> LeftOuterJoin_KbEntryComment_KbEntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbEntryCommentTableInfo>

LeftOuterJoin_KbEntryKeyword_KbEntryId

Generated left outer join from the primary key KbEntryId on this table, to KbEntryKeyword.KbEntryId.

Declaration

public TargetedLeftOuterJoin<KbEntryKeywordTableInfo> LeftOuterJoin_KbEntryKeyword_KbEntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbEntryKeywordTableInfo>

LeftOuterJoin_KbEntryLog_KbEntryId

Generated left outer join from the primary key KbEntryId on this table, to KbEntryLog.KbEntryId.

Declaration

public TargetedLeftOuterJoin<KbEntryLogTableInfo> LeftOuterJoin_KbEntryLog_KbEntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbEntryLogTableInfo>

LeftOuterJoin_KbGroupEntry_KbEntryId

Generated left outer join from the primary key KbEntryId on this table, to KbGroupEntry.KbEntryId.

Declaration

public TargetedLeftOuterJoin<KbGroupEntryTableInfo> LeftOuterJoin_KbGroupEntry_KbEntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbGroupEntryTableInfo>

LeftOuterJoin_KbHttpLink_EntryId

Generated left outer join from the primary key KbEntryId on this table, to KbHttpLink.EntryId.

Declaration

public TargetedLeftOuterJoin<KbHttpLinkTableInfo> LeftOuterJoin_KbHttpLink_EntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbHttpLinkTableInfo>

LeftOuterJoin_KbSolutionFinderEntry_KbEntry

Generated left outer join from the primary key KbEntryId on this table, to KbSolutionFinderEntry.KbEntry.

Declaration

public TargetedLeftOuterJoin<KbSolutionFinderEntryTableInfo> LeftOuterJoin_KbSolutionFinderEntry_KbEntry { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<KbSolutionFinderEntryTableInfo>

LeftOuterJoin_WordRelations_EntryId

Generated left outer join from the primary key KbEntryId on this table, to WordRelations.EntryId.

Declaration

public TargetedLeftOuterJoin<WordRelationsTableInfo> LeftOuterJoin_WordRelations_EntryId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WordRelationsTableInfo>

Question

Field 'question' in table 'kb_entry': Dictionary type Clob, .NET type: String

The question for this entry.

Declaration

public StringFieldInfo Question { get; }

Property Value

Type	Description
StringFieldInfo

ReadCount

Field 'read_count' in table 'kb_entry': Dictionary type Int, .NET type: Int32

The number of times someone has read this entry from the customer frontend.

Declaration

public Int32FieldInfo ReadCount { get; }

Property Value

Type	Description
Int32FieldInfo

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration

[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }

Property Value

Type	Description
SoTable

Score

Field 'score' in table 'kb_entry': Dictionary type Int, .NET type: Int32

The accumulated score (0..100) for this entry.

Declaration

public Int32FieldInfo Score { get; }

Property Value

Type	Description
Int32FieldInfo

ScoreWeight

Field 'score_weight' in table 'kb_entry': Dictionary type Int, .NET type: Int32

The number of votes behind the accumulated score.

Declaration

public Int32FieldInfo ScoreWeight { get; }

Property Value

Type	Description
Int32FieldInfo

SortOrder

Field 'sort_order' in table 'kb_entry': Dictionary type Int, .NET type: Int32

A scrictly ascending number indicating the sort-order when listing entries.

Declaration

public Int32FieldInfo SortOrder { get; }

Property Value

Type	Description
Int32FieldInfo

Status

Field 'status' in table 'kb_entry': Dictionary type Enum, .NET type: Int16

The status for this entry (enum).

Declaration

public UInt16FieldInfo Status { get; }

Property Value

Type	Description
UInt16FieldInfo

Title

Field 'title' in table 'kb_entry': Dictionary type String[256], .NET type: String

The title of this entry.

Declaration

public StringFieldInfo Title { get; }

Property Value

Type	Description
StringFieldInfo

WorkflowPhase

Field 'workflow_phase' in table 'kb_entry': Dictionary type FK, .NET type: Int32

The workflow phase this entry is in

Declaration

public Int32FieldInfo WorkflowPhase { get; }

Property Value

Type	Description
Int32FieldInfo

WorkflowPhase_InnerJoin_KbWorkflow

Generated join from the foreign key WorkflowPhase in this table, to its target table KbWorkflowTableInfo.

Declaration

public TargetedInnerJoin<KbWorkflowTableInfo> WorkflowPhase_InnerJoin_KbWorkflow { get; }

Property Value

Type	Description
TargetedInnerJoin<KbWorkflowTableInfo>

Methods

IdxTitle(String)

Shortcut method for looking up using the database index Title, which spans the following fields:

Field	Description
Title	The title of this entry.

Declaration

public Restriction IdxTitle(string title)

Parameters

Type	Name	Description
String	title

Returns

Type	Description
Restriction

IdxTitleQuestion(String, String)

Shortcut method for looking up using the database index TitleQuestion, which spans the following fields:

Field	Description
Title	The title of this entry.
Question	The question for this entry.

Declaration

public Restriction IdxTitleQuestion(string title, string question)

Parameters

Type	Name	Description
String	title
String	question

Returns

Type	Description
Restriction

IdxTitleQuestionAnswer(String, String, String)

Shortcut method for looking up using the database index TitleQuestionAnswer, which spans the following fields:

Field	Description
Title	The title of this entry.
Question	The question for this entry.
Answer	The answer for this entry.

Declaration

public Restriction IdxTitleQuestionAnswer(string title, string question, string answer)

Parameters

Type	Name	Description
String	title
String	question
String	answer

Returns

Type	Description
Restriction

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)