Class WorkflowTableInfo

Table 'workflow': SuperOffice specific info about a workflow

Inheritance

object

TableInfo

WorkflowTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(params FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(string)

TableInfo.ProtAll

TableInfo.UseNolockIfPossible

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.this[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("workflow")]
public class WorkflowTableInfo : 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 TablesInfo.GetWorkflowInfo().

Fields

DictionaryTableName

Conceptual name of table Workflow in the database dictionary: workflow

Declaration

public const string DictionaryTableName = "workflow"

Field Value

Type	Description
string

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 TablesInfo.GetWorkflowInfo().

Properties

AssociateId

Field 'associate_id' in table 'workflow': Dictionary type FK, target: Associate, .NET type: int

Associate who owns this workflow

Declaration

public Int32FieldInfo AssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

AssociateId_InnerJoin_Associate

Generated join from the foreign key AssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> AssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 TablesInfo.GetWorkflowInfo().

BlockLists

Field 'block_lists' in table 'workflow': Dictionary type FKArray, .NET type: int

Persons in the given selections are not allowed to enter this workflow

Declaration

public Int32ArrayFieldInfo BlockLists { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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 TablesInfo.GetWorkflowInfo().

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

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 TablesInfo.GetWorkflowInfo().

Description

Field 'description' in table 'workflow': Dictionary type String[4001], .NET type: string

Description of the workflow

Declaration

public StringFieldInfo Description { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetWorkflowInfo().

DictionaryTableNumber

Table number for table Workflow 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
int

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 TablesInfo.GetWorkflowInfo().

EnrollmentEnd

Field 'enrollment_end' in table 'workflow': Dictionary type UtcDateTime, .NET type: DateTime

Do not enroll more participant after given time, interpreted in stored timezone or as UTC

Declaration

public DateTimeFieldInfo EnrollmentEnd { get; }

Property Value

Type	Description
DateTimeFieldInfo

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 TablesInfo.GetWorkflowInfo().

ExitFlowId

Field 'exit_flow_id' in table 'workflow': Dictionary type FK, target: Workflow, .NET type: int

On exit with no success criteria met, we attempt to add the participant to the given flow

Declaration

public Int32FieldInfo ExitFlowId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

ExitFlowId_InnerJoin_Workflow

Generated join from the foreign key ExitFlowId in this table, to its target table WorkflowTableInfo.

Declaration

public TargetedInnerJoin<WorkflowTableInfo> ExitFlowId_InnerJoin_Workflow { get; }

Property Value

Type	Description
TargetedInnerJoin<WorkflowTableInfo>

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 TablesInfo.GetWorkflowInfo().

ExitSuccessFlowId

Field 'exit_success_flow_id' in table 'workflow': Dictionary type FK, target: Workflow, .NET type: int

On exit with success criteria met, we attempt to add the participant to the given flow

Declaration

public Int32FieldInfo ExitSuccessFlowId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

ExitSuccessFlowId_InnerJoin_Workflow

Generated join from the foreign key ExitSuccessFlowId in this table, to its target table WorkflowTableInfo.

Declaration

public TargetedInnerJoin<WorkflowTableInfo> ExitSuccessFlowId_InnerJoin_Workflow { get; }

Property Value

Type	Description
TargetedInnerJoin<WorkflowTableInfo>

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 TablesInfo.GetWorkflowInfo().

GroupId

Field 'group_id' in table 'workflow': Dictionary type FK, target: UserGroup, .NET type: int

Group id of original owning associate, so that changes to owner's primary group do not influence group membership of this workflow.

Declaration

public Int32FieldInfo GroupId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

GroupId_InnerJoin_UserGroup

Generated join from the foreign key GroupId in this table, to its target table UserGroupTableInfo.

Declaration

public TargetedInnerJoin<UserGroupTableInfo> GroupId_InnerJoin_UserGroup { get; }

Property Value

Type	Description
TargetedInnerJoin<UserGroupTableInfo>

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 TablesInfo.GetWorkflowInfo().

JumpToFinish

Field 'jump_to_finish' in table 'workflow': Dictionary type Bool, .NET type: short

When a goal is reached, contact jumps directly to finished

Declaration

public UInt16FieldInfo JumpToFinish { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_Appointment_CreatedByWorkflowId

Generated left outer join from the primary key WorkflowId on this table, to Appointment.CreatedByWorkflowId.

Declaration

public TargetedLeftOuterJoin<AppointmentTableInfo> LeftOuterJoin_Appointment_CreatedByWorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<AppointmentTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_EmailFlow_WorkflowId

Generated left outer join from the primary key WorkflowId on this table, to EmailFlow.WorkflowId.

Declaration

public TargetedLeftOuterJoin<EmailFlowTableInfo> LeftOuterJoin_EmailFlow_WorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<EmailFlowTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_Person_ModifiedByWorkflowId

Generated left outer join from the primary key WorkflowId on this table, to Person.ModifiedByWorkflowId.

Declaration

public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_ModifiedByWorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<PersonTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_Sale_CreatedByWorkflowId

Generated left outer join from the primary key WorkflowId on this table, to Sale.CreatedByWorkflowId.

Declaration

public TargetedLeftOuterJoin<SaleTableInfo> LeftOuterJoin_Sale_CreatedByWorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<SaleTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_Ticket_CreatedByWorkflowId

Generated left outer join from the primary key WorkflowId on this table, to Ticket.CreatedByWorkflowId.

Declaration

public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_CreatedByWorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_WorkflowGoal_WorkflowId

Generated left outer join from the primary key WorkflowId on this table, to WorkflowGoal.WorkflowId.

Declaration

public TargetedLeftOuterJoin<WorkflowGoalTableInfo> LeftOuterJoin_WorkflowGoal_WorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowGoalTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_WorkflowInstance_WorkflowId

Generated left outer join from the primary key WorkflowId on this table, to WorkflowInstance.WorkflowId.

Declaration

public TargetedLeftOuterJoin<WorkflowInstanceTableInfo> LeftOuterJoin_WorkflowInstance_WorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowInstanceTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_WorkflowRootStepLink_WorkflowId

Generated left outer join from the primary key WorkflowId on this table, to WorkflowRootStepLink.WorkflowId.

Declaration

public TargetedLeftOuterJoin<WorkflowRootStepLinkTableInfo> LeftOuterJoin_WorkflowRootStepLink_WorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowRootStepLinkTableInfo>

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 TablesInfo.GetWorkflowInfo().

LeftOuterJoin_WorkflowTrigger_WorkflowId

Generated left outer join from the primary key WorkflowId on this table, to WorkflowTrigger.WorkflowId.

Declaration

public TargetedLeftOuterJoin<WorkflowTriggerTableInfo> LeftOuterJoin_WorkflowTrigger_WorkflowId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<WorkflowTriggerTableInfo>

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 TablesInfo.GetWorkflowInfo().

Name

Field 'name' in table 'workflow': Dictionary type String[256], .NET type: string

Name of the workflow

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

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 TablesInfo.GetWorkflowInfo().

Registered

Field 'registered' in table 'workflow': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration

public DateTimeFieldInfo Registered { get; }

Property Value

Type	Description
DateTimeFieldInfo

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 TablesInfo.GetWorkflowInfo().

RegisteredAssociateId

Field 'registered_associate_id' in table 'workflow': Dictionary type FK, target: Associate, .NET type: int

Registered by whom

Declaration

public Int32FieldInfo RegisteredAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 TablesInfo.GetWorkflowInfo().

RemoveFromFlows

Field 'remove_from_flows' in table 'workflow': Dictionary type FKArray, .NET type: int

Workflows to remove the participants from when they are enrolled in this workflow

Declaration

public Int32ArrayFieldInfo RemoveFromFlows { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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 TablesInfo.GetWorkflowInfo().

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

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 TablesInfo.GetWorkflowInfo().

StartOnlyOnce

Field 'start_only_once' in table 'workflow': Dictionary type Bool, .NET type: short

A contact can start this flow only once

Declaration

public UInt16FieldInfo StartOnlyOnce { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

Status

Field 'status' in table 'workflow': Dictionary type Enum, .NET type: WorkflowDefinitionStatus

Status of the workflow definition

Declaration

public WorkflowDefinitionStatusFieldInfo Status { get; }

Property Value

Type	Description
WorkflowDefinitionStatusFieldInfo

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 TablesInfo.GetWorkflowInfo().

TzLocationId

Field 'tzLocationId' in table 'workflow': Dictionary type FK, target: TZLocation, .NET type: int

Timezone used for this workflows datetimes. If not set, behavior is best guess - databasetime, system time...

Declaration

public Int32FieldInfo TzLocationId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

TzLocationId_InnerJoin_TZLocation

Generated join from the foreign key TzLocationId in this table, to its target table TZLocationTableInfo.

Declaration

public TargetedInnerJoin<TZLocationTableInfo> TzLocationId_InnerJoin_TZLocation { get; }

Property Value

Type	Description
TargetedInnerJoin<TZLocationTableInfo>

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 TablesInfo.GetWorkflowInfo().

Updated

Field 'updated' in table 'workflow': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration

public DateTimeFieldInfo Updated { get; }

Property Value

Type	Description
DateTimeFieldInfo

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 TablesInfo.GetWorkflowInfo().

UpdatedAssociateId

Field 'updated_associate_id' in table 'workflow': Dictionary type FK, target: Associate, .NET type: int

Last updated by whom

Declaration

public Int32FieldInfo UpdatedAssociateId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration

public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }

Property Value

Type	Description
TargetedInnerJoin<AssociateTableInfo>

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 TablesInfo.GetWorkflowInfo().

UpdatedCount

Field 'updatedCount' in table 'workflow': Dictionary type UShort, .NET type: short

Number of updates made to this record

Declaration

public UInt16FieldInfo UpdatedCount { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

UseEnrollmentEnd

Field 'use_enrollment_end' in table 'workflow': Dictionary type Bool, .NET type: short

End enrollment into the workflow at the given time

Declaration

public UInt16FieldInfo UseEnrollmentEnd { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

UseWorkflowStart

Field 'use_workflow_start' in table 'workflow': Dictionary type Bool, .NET type: short

Start the flow running with enrolled participants at the given time

Declaration

public UInt16FieldInfo UseWorkflowStart { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

VisibleForAll

Field 'visible_for_all' in table 'workflow': Dictionary type Bool, .NET type: short

True if visible for all

Declaration

public UInt16FieldInfo VisibleForAll { get; }

Property Value

Type	Description
UInt16FieldInfo

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 TablesInfo.GetWorkflowInfo().

VisibleForAssociates

Field 'visible_for_associates' in table 'workflow': Dictionary type FKArray, .NET type: int

Array of references to the visible for associates

Declaration

public Int32ArrayFieldInfo VisibleForAssociates { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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 TablesInfo.GetWorkflowInfo().

VisibleForGroups

Field 'visible_for_groups' in table 'workflow': Dictionary type FKArray, .NET type: int

Array of references to the visible for groups

Declaration

public Int32ArrayFieldInfo VisibleForGroups { get; }

Property Value

Type	Description
Int32ArrayFieldInfo

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 TablesInfo.GetWorkflowInfo().

WorkflowId

Field 'workflow_id' in table 'workflow': Dictionary type PK, .NET type: int

Primary key

Declaration

public Int32FieldInfo WorkflowId { get; }

Property Value

Type	Description
Int32FieldInfo

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 TablesInfo.GetWorkflowInfo().

WorkflowStart

Field 'workflow_start' in table 'workflow': Dictionary type UtcDateTime, .NET type: DateTime

When to start running the workflow. Until start, any enrolled members are not running through the flow, just waiting. Datetime is interpreted in stored timezone or as UTC

Declaration

public DateTimeFieldInfo WorkflowStart { get; }

Property Value

Type	Description
DateTimeFieldInfo

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 TablesInfo.GetWorkflowInfo().

Methods

IdxVisibleForAssociates(int[])

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

Field	Description
VisibleForAssociates	Array of references to the visible for associates

Declaration

public Restriction IdxVisibleForAssociates(int[] visibleForAssociates)

Parameters

Type	Name	Description
int[]	visibleForAssociates

Returns

Type	Description
Restriction

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 TablesInfo.GetWorkflowInfo().

IdxVisibleForAssociatesVisibleForGroups(int[], int[])

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

Field	Description
VisibleForAssociates	Array of references to the visible for associates
VisibleForGroups	Array of references to the visible for groups

Declaration

public Restriction IdxVisibleForAssociatesVisibleForGroups(int[] visibleForAssociates, int[] visibleForGroups)

Parameters

Type	Name	Description
int[]	visibleForAssociates
int[]	visibleForGroups

Returns

Type	Description
Restriction

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 TablesInfo.GetWorkflowInfo().

IdxVisibleForAssociatesVisibleForGroupsRemoveFromFlows(int[], int[], int[])

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

Field	Description
VisibleForAssociates	Array of references to the visible for associates
VisibleForGroups	Array of references to the visible for groups
RemoveFromFlows	Workflows to remove the participants from when they are enrolled in this workflow

Declaration

public Restriction IdxVisibleForAssociatesVisibleForGroupsRemoveFromFlows(int[] visibleForAssociates, int[] visibleForGroups, int[] removeFromFlows)

Parameters

Type	Name	Description
int[]	visibleForAssociates
int[]	visibleForGroups
int[]	removeFromFlows

Returns

Type	Description
Restriction

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 TablesInfo.GetWorkflowInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)