Class KbWorkflowAccessTableInfo

Table 'kb_workflow_access': Control of who can do what in a knowledge base workflow step

Inheritance
System.Object
TableInfo
KbWorkflowAccessTableInfo
Implements
System.ICloneable
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("kb_workflow_access")]
public class KbWorkflowAccessTableInfo : 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 KbWorkflowAccess in the database dictionary: kb_workflow_access

Declaration
public const string DictionaryTableName = "kb_workflow_access"
Field Value
Type Description
System.String

Properties

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

Table number for table KbWorkflowAccess 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
System.Int32

KbAccess

Field 'kb_access' in table 'kb_workflow_access': Dictionary type Enum, .NET type: System.Int16

The access given to a user for entries in a given workflow phase. 1 for viewing entries, 2 for moving entries between workflow phases, 3 for editing entries

Declaration
public UInt16FieldInfo KbAccess { get; }
Property Value
Type Description
UInt16FieldInfo

KbWorkflow

Field 'kb_workflow' in table 'kb_workflow_access': Dictionary type FK, target: KbWorkflow, .NET type: System.Int32

The workflow to access.

Declaration
public Int32FieldInfo KbWorkflow { get; }
Property Value
Type Description
Int32FieldInfo

KbWorkflow_InnerJoin_KbWorkflow

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

Declaration
public TargetedInnerJoin<KbWorkflowTableInfo> KbWorkflow_InnerJoin_KbWorkflow { get; }
Property Value
Type Description
TargetedInnerJoin<KbWorkflowTableInfo>

KbWorkflowAccessId

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

The primary key (auto-incremented)

Declaration
public Int32FieldInfo KbWorkflowAccessId { get; }
Property Value
Type Description
Int32FieldInfo

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

UserId

Field 'user_id' in table 'kb_workflow_access': Dictionary type FK, target: Ejuser, .NET type: System.Int32

The user with access.

Declaration
public Int32FieldInfo UserId { get; }
Property Value
Type Description
Int32FieldInfo

UserId_InnerJoin_Ejuser

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

Declaration
public TargetedInnerJoin<EjuserTableInfo> UserId_InnerJoin_Ejuser { get; }
Property Value
Type Description
TargetedInnerJoin<EjuserTableInfo>

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)