Show / Hide Table of Contents

Class EjuserTableInfo

Table 'ejuser': This table contains entries for the users of the system.

Inheritance
object
TableInfo
EjuserTableInfo
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("ejuser")]
public class EjuserTableInfo : 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.GetEjuserInfo().

Fields

DictionaryTableName

Conceptual name of table Ejuser in the database dictionary: ejuser

Declaration
public const string DictionaryTableName = "ejuser"
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.GetEjuserInfo().

Properties

AccessLevel

Field 'access_level' in table 'ejuser': Dictionary type Int, .NET type: int

The access level for this user.
Declaration
public Int32FieldInfo AccessLevel { 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.GetEjuserInfo().

ChatStatus

Field 'chat_status' in table 'ejuser': Dictionary type Enum, .NET type: ChatStatus

Various chat statuses for an agent
Declaration
public ChatStatusFieldInfo ChatStatus { get; }
Property Value
Type Description
ChatStatusFieldInfo
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.GetEjuserInfo().

DateFormat

Field 'date_format' in table 'ejuser': Dictionary type Enum, .NET type: short

The preferred format of dates and datetimes (enum) for this user.
Declaration
public UInt16FieldInfo DateFormat { 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.GetEjuserInfo().

DateFormatLongString

Field 'date_format_long_string' in table 'ejuser': Dictionary type String[65], .NET type: string

Chosen date format for lists as a string for this user
Declaration
public StringFieldInfo DateFormatLongString { 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.GetEjuserInfo().

DateFormatString

Field 'date_format_string' in table 'ejuser': Dictionary type String[65], .NET type: string

Chosen date format as a string for this user
Declaration
public StringFieldInfo DateFormatString { 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.GetEjuserInfo().

DbiAgentId

Field 'dbi_agent_id' in table 'ejuser': Dictionary type FK, target: DbiAgent, .NET type: int

Integration agent (eJournal)
Declaration
public Int32FieldInfo DbiAgentId { 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.GetEjuserInfo().

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>
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.GetEjuserInfo().

DbiKey

Field 'dbi_key' in table 'ejuser': 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
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.GetEjuserInfo().

DbiLastModified

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

When the entry was last modified.
Declaration
public DateTimeFieldInfo DbiLastModified { 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.GetEjuserInfo().

DbiLastSyncronized

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

Last external syncronization.
Declaration
public DateTimeFieldInfo DbiLastSyncronized { 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.GetEjuserInfo().

DefaultCategory

Field 'default_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: int

The default category for this user when posting tickets and use_last_category is false.
Declaration
public Int32FieldInfo DefaultCategory { 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.GetEjuserInfo().

DefaultCategory_InnerJoin_EjCategory

Generated join from the foreign key DefaultCategory in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> DefaultCategory_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>
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.GetEjuserInfo().

DefaultStatusAddMessage

Field 'default_status_add_message' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: int

Default status on add message.
Declaration
public Int32FieldInfo DefaultStatusAddMessage { 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.GetEjuserInfo().

DefaultStatusAddMessage_InnerJoin_TicketStatus

Generated join from the foreign key DefaultStatusAddMessage in this table, to its target table TicketStatusTableInfo.

Declaration
public TargetedInnerJoin<TicketStatusTableInfo> DefaultStatusAddMessage_InnerJoin_TicketStatus { get; }
Property Value
Type Description
TargetedInnerJoin<TicketStatusTableInfo>
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.GetEjuserInfo().

DefaultStatusNewTicket

Field 'default_status_new_ticket' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: int

Default status on new requests.
Declaration
public Int32FieldInfo DefaultStatusNewTicket { 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.GetEjuserInfo().

DefaultStatusNewTicket_InnerJoin_TicketStatus

Generated join from the foreign key DefaultStatusNewTicket in this table, to its target table TicketStatusTableInfo.

Declaration
public TargetedInnerJoin<TicketStatusTableInfo> DefaultStatusNewTicket_InnerJoin_TicketStatus { get; }
Property Value
Type Description
TargetedInnerJoin<TicketStatusTableInfo>
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.GetEjuserInfo().

DefaultUser

Field 'default_user' in table 'ejuser': Dictionary type Int, .NET type: int

The default user to set on new tickets in this category (1=automatically, 2=unasigned, 3=the owner
Declaration
public Int32FieldInfo DefaultUser { 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.GetEjuserInfo().

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.GetEjuserInfo().

Dictionary

Field 'dictionary' in table 'ejuser': Dictionary type String[6], .NET type: string

A string indicating the user's prefered dictionary language ('no' or 'en').
Declaration
public StringFieldInfo Dictionary { 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.GetEjuserInfo().

DictionaryTableNumber

Table number for table Ejuser 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.GetEjuserInfo().

EjuserId

Field 'id' in table 'ejuser': Dictionary type PK, .NET type: int

The primary key (auto-incremented)
Declaration
public Int32FieldInfo EjuserId { 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.GetEjuserInfo().

Email

Field 'email' in table 'ejuser': Dictionary type String[256], .NET type: string

The email address for this user.
Declaration
public StringFieldInfo Email { 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.GetEjuserInfo().

EmailMask

Field 'email_mask' in table 'ejuser': Dictionary type Int, .NET type: int

A bitmask indicated to which extent the user should recieve email warnings for various events.
Declaration
public Int32FieldInfo EmailMask { 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.GetEjuserInfo().

Firstname

Field 'firstname' in table 'ejuser': Dictionary type String[128], .NET type: string

The firstname for this user.
Declaration
public StringFieldInfo Firstname { 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.GetEjuserInfo().

Flags

Field 'flags' in table 'ejuser': Dictionary type Int, .NET type: int

A bitmask indicating flags for this entry.
Declaration
public Int32FieldInfo Flags { 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.GetEjuserInfo().

HiddenBagBitset

Field 'hidden_bag_bitset' in table 'ejuser': Dictionary type String[256], .NET type: string

Each character represent a bit to set a HtmlBagHideable to default open or closed (1=open 0=closed)
Declaration
public StringFieldInfo HiddenBagBitset { 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.GetEjuserInfo().

IdleTime

Field 'idle_time' in table 'ejuser': Dictionary type Int, .NET type: int

Number of seconds the user has been idle. Updated by TrayIcon or simular external programs.
Declaration
public Int32FieldInfo IdleTime { 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.GetEjuserInfo().

Language

Field 'language' in table 'ejuser': Dictionary type String[6], .NET type: string

A string indicating the user's language ('no' or 'en').
Declaration
public StringFieldInfo Language { 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.GetEjuserInfo().

LastCategory

Field 'last_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: int

The last chosen category for this user when posting tickets.
Declaration
public Int32FieldInfo LastCategory { 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.GetEjuserInfo().

LastCategory_InnerJoin_EjCategory

Generated join from the foreign key LastCategory in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> LastCategory_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>
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.GetEjuserInfo().

LastLoginAttempt

Field 'last_login_attempt' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

The last time the user tried to log in without success
Declaration
public DateTimeFieldInfo LastLoginAttempt { 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.GetEjuserInfo().

Lastname

Field 'lastname' in table 'ejuser': Dictionary type String[128], .NET type: string

The lastname for this user.
Declaration
public StringFieldInfo Lastname { 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.GetEjuserInfo().

LeftOuterJoin_Associate_EjUserId

Generated left outer join from the primary key EjuserId on this table, to Associate.EjUserId.

Declaration
public TargetedLeftOuterJoin<AssociateTableInfo> LeftOuterJoin_Associate_EjUserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<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.GetEjuserInfo().

LeftOuterJoin_CategoryMembership_UserId

Generated left outer join from the primary key EjuserId on this table, to CategoryMembership.UserId.

Declaration
public TargetedLeftOuterJoin<CategoryMembershipTableInfo> LeftOuterJoin_CategoryMembership_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CategoryMembershipTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ChatMessage_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to ChatMessage.CreatedBy.

Declaration
public TargetedLeftOuterJoin<ChatMessageTableInfo> LeftOuterJoin_ChatMessage_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatMessageTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ChatSession_TransferTo

Generated left outer join from the primary key EjuserId on this table, to ChatSession.TransferTo.

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_TransferTo { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ChatSession_UserId

Generated left outer join from the primary key EjuserId on this table, to ChatSession.UserId.

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ChatTopicUser_UserId

Generated left outer join from the primary key EjuserId on this table, to ChatTopicUser.UserId.

Declaration
public TargetedLeftOuterJoin<ChatTopicUserTableInfo> LeftOuterJoin_ChatTopicUser_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatTopicUserTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Dictionary_UserId

Generated left outer join from the primary key EjuserId on this table, to Dictionary.UserId.

Declaration
public TargetedLeftOuterJoin<DictionaryTableInfo> LeftOuterJoin_Dictionary_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DictionaryTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_DocDocument_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to DocDocument.ChangedBy.

Declaration
public TargetedLeftOuterJoin<DocDocumentTableInfo> LeftOuterJoin_DocDocument_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocDocumentTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_DocDocument_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to DocDocument.CreatedBy.

Declaration
public TargetedLeftOuterJoin<DocDocumentTableInfo> LeftOuterJoin_DocDocument_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocDocumentTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_DocFolder_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to DocFolder.CreatedBy.

Declaration
public TargetedLeftOuterJoin<DocFolderTableInfo> LeftOuterJoin_DocFolder_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocFolderTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_EjCategory_CategoryMaster

Generated left outer join from the primary key EjuserId on this table, to EjCategory.CategoryMaster.

Declaration
public TargetedLeftOuterJoin<EjCategoryTableInfo> LeftOuterJoin_EjCategory_CategoryMaster { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjCategoryTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_EjMessage_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to EjMessage.ChangedBy.

Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjMessageTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_EjMessage_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to EjMessage.CreatedBy.

Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjMessageTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Ejpackage_UploadedBy

Generated left outer join from the primary key EjuserId on this table, to Ejpackage.UploadedBy.

Declaration
public TargetedLeftOuterJoin<EjpackageTableInfo> LeftOuterJoin_Ejpackage_UploadedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjpackageTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_EjselMetaResult_Owner

Generated left outer join from the primary key EjuserId on this table, to EjselMetaResult.Owner.

Declaration
public TargetedLeftOuterJoin<EjselMetaResultTableInfo> LeftOuterJoin_EjselMetaResult_Owner { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjselMetaResultTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Ejselection_Creator

Generated left outer join from the primary key EjuserId on this table, to Ejselection.Creator.

Declaration
public TargetedLeftOuterJoin<EjselectionTableInfo> LeftOuterJoin_Ejselection_Creator { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjselectionTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ElementProfile_OwnedByUser

Generated left outer join from the primary key EjuserId on this table, to ElementProfile.OwnedByUser.

Declaration
public TargetedLeftOuterJoin<ElementProfileTableInfo> LeftOuterJoin_ElementProfile_OwnedByUser { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ElementProfileTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ExternalDocument_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to ExternalDocument.ChangedBy.

Declaration
public TargetedLeftOuterJoin<ExternalDocumentTableInfo> LeftOuterJoin_ExternalDocument_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExternalDocumentTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ExternalDocument_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to ExternalDocument.CreatedBy.

Declaration
public TargetedLeftOuterJoin<ExternalDocumentTableInfo> LeftOuterJoin_ExternalDocument_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExternalDocumentTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Hotlist_UserId

Generated left outer join from the primary key EjuserId on this table, to Hotlist.UserId.

Declaration
public TargetedLeftOuterJoin<HotlistTableInfo> LeftOuterJoin_Hotlist_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<HotlistTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_KbCategoryLog_UserId

Generated left outer join from the primary key EjuserId on this table, to KbCategoryLog.UserId.

Declaration
public TargetedLeftOuterJoin<KbCategoryLogTableInfo> LeftOuterJoin_KbCategoryLog_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbCategoryLogTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_KbCategory_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to KbCategory.CreatedBy.

Declaration
public TargetedLeftOuterJoin<KbCategoryTableInfo> LeftOuterJoin_KbCategory_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbCategoryTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_KbEntryLog_UserId

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

Declaration
public TargetedLeftOuterJoin<KbEntryLogTableInfo> LeftOuterJoin_KbEntryLog_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbEntryLogTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_KbEntry_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to KbEntry.CreatedBy.

Declaration
public TargetedLeftOuterJoin<KbEntryTableInfo> LeftOuterJoin_KbEntry_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbEntryTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_KbWorkflowAccess_UserId

Generated left outer join from the primary key EjuserId on this table, to KbWorkflowAccess.UserId.

Declaration
public TargetedLeftOuterJoin<KbWorkflowAccessTableInfo> LeftOuterJoin_KbWorkflowAccess_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbWorkflowAccessTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Login_UserId

Generated left outer join from the primary key EjuserId on this table, to Login.UserId.

Declaration
public TargetedLeftOuterJoin<LoginTableInfo> LeftOuterJoin_Login_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<LoginTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_MsFilter_NewOwner

Generated left outer join from the primary key EjuserId on this table, to MsFilter.NewOwner.

Declaration
public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_NewOwner { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MsFilterTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Notify_OwnerId

Generated left outer join from the primary key EjuserId on this table, to Notify.OwnerId.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_OwnerId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Notify_User2Id

Generated left outer join from the primary key EjuserId on this table, to Notify.User2Id.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_User2Id { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Notify_UserId

Generated left outer join from the primary key EjuserId on this table, to Notify.UserId.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Profile_UserId

Generated left outer join from the primary key EjuserId on this table, to Profile.UserId.

Declaration
public TargetedLeftOuterJoin<ProfileTableInfo> LeftOuterJoin_Profile_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ProfileTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_ReplyTemplate_OwnedBy

Generated left outer join from the primary key EjuserId on this table, to ReplyTemplate.OwnedBy.

Declaration
public TargetedLeftOuterJoin<ReplyTemplateTableInfo> LeftOuterJoin_ReplyTemplate_OwnedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ReplyTemplateTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_RoleMember_Ejuser

Generated left outer join from the primary key EjuserId on this table, to RoleMember.Ejuser.

Declaration
public TargetedLeftOuterJoin<RoleMemberTableInfo> LeftOuterJoin_RoleMember_Ejuser { get; }
Property Value
Type Description
TargetedLeftOuterJoin<RoleMemberTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_SLink_TicketOwnedBy

Generated left outer join from the primary key EjuserId on this table, to SLink.TicketOwnedBy.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TicketOwnedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_TicketAlert_DelegateTo

Generated left outer join from the primary key EjuserId on this table, to TicketAlert.DelegateTo.

Declaration
public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_DelegateTo { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketAlertTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_TicketLogAction_UserId

Generated left outer join from the primary key EjuserId on this table, to TicketLogAction.UserId.

Declaration
public TargetedLeftOuterJoin<TicketLogActionTableInfo> LeftOuterJoin_TicketLogAction_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketLogActionTableInfo>
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.GetEjuserInfo().

LeftOuterJoin_Ticket_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to Ticket.CreatedBy.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_CreatedBy { 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.GetEjuserInfo().

LeftOuterJoin_Ticket_OwnedBy

Generated left outer join from the primary key EjuserId on this table, to Ticket.OwnedBy.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_OwnedBy { 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.GetEjuserInfo().

LeftOuterJoin_UserAttribute_UserId

Generated left outer join from the primary key EjuserId on this table, to UserAttribute.UserId.

Declaration
public TargetedLeftOuterJoin<UserAttributeTableInfo> LeftOuterJoin_UserAttribute_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<UserAttributeTableInfo>
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.GetEjuserInfo().

LoginAttempts

Field 'login_attempts' in table 'ejuser': Dictionary type Int, .NET type: int

The number of times the user has attempted to login with the wrong password
Declaration
public Int32FieldInfo LoginAttempts { 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.GetEjuserInfo().

Loginname

Field 'loginname' in table 'ejuser': Dictionary type String[64], .NET type: string

The unique loginname for this user.
Declaration
public StringFieldInfo Loginname { 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.GetEjuserInfo().

Middlename

Field 'middlename' in table 'ejuser': Dictionary type String[128], .NET type: string

The middlename for this user.
Declaration
public StringFieldInfo Middlename { 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.GetEjuserInfo().

MinuteOffset

Field 'minute_offset' in table 'ejuser': Dictionary type Int, .NET type: int

Offset in hours between server and ejuser timezone.
Declaration
public Int32FieldInfo MinuteOffset { 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.GetEjuserInfo().

NewGui

Field 'new_gui' in table 'ejuser': Dictionary type Bool, .NET type: short

Whether to use the new gui or not
Declaration
public UInt16FieldInfo NewGui { 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.GetEjuserInfo().

NotPresent

Field 'not_present' in table 'ejuser': Dictionary type String[256], .NET type: string

Comment to add for user when status is not present.
Declaration
public StringFieldInfo NotPresent { 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.GetEjuserInfo().

NotifyExternalLock

Field 'notify_external_lock' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

A datetime lock to make sure notifications are only displayed by one notifcation system (ejournal or external programs)
Declaration
public DateTimeFieldInfo NotifyExternalLock { 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.GetEjuserInfo().

NotifyExternalSource

Field 'notify_external_source' in table 'ejuser': Dictionary type String[256], .NET type: string

A name (id) of the external notifications system (ejournal or external programs)
Declaration
public StringFieldInfo NotifyExternalSource { 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.GetEjuserInfo().

NotifyMask

Field 'notify_mask' in table 'ejuser': Dictionary type Int, .NET type: int

A bitmask indicating to which extent the user should recieve pop-up warnings for various events.
Declaration
public Int32FieldInfo NotifyMask { 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.GetEjuserInfo().

NumExpandedMessages

Field 'num_expanded_messages' in table 'ejuser': Dictionary type Int, .NET type: int

The number of expanded messages in show-ticket view.
Declaration
public Int32FieldInfo NumExpandedMessages { 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.GetEjuserInfo().

Password

Field 'password' in table 'ejuser': Dictionary type String[128], .NET type: string

The encrypted password for this user.
Declaration
public StringFieldInfo Password { 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.GetEjuserInfo().

PictureId

Field 'picture_id' in table 'ejuser': Dictionary type FK, target: Attachment, .NET type: int

The attachment.id this reference is connected to.
Declaration
public Int32FieldInfo PictureId { 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.GetEjuserInfo().

PictureId_InnerJoin_Attachment

Generated join from the foreign key PictureId in this table, to its target table AttachmentTableInfo.

Declaration
public TargetedInnerJoin<AttachmentTableInfo> PictureId_InnerJoin_Attachment { get; }
Property Value
Type Description
TargetedInnerJoin<AttachmentTableInfo>
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.GetEjuserInfo().

ProfileId

Field 'profile_id' in table 'ejuser': Dictionary type FK, target: Profile, .NET type: int

Reference to the profile connected to this ejuser
Declaration
public Int32FieldInfo ProfileId { 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.GetEjuserInfo().

ProfileId_InnerJoin_Profile

Generated join from the foreign key ProfileId in this table, to its target table ProfileTableInfo.

Declaration
public TargetedInnerJoin<ProfileTableInfo> ProfileId_InnerJoin_Profile { get; }
Property Value
Type Description
TargetedInnerJoin<ProfileTableInfo>
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.GetEjuserInfo().

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.GetEjuserInfo().

Signature

Field 'signature' in table 'ejuser': Dictionary type Clob, .NET type: string

The users signature.
Declaration
public StringFieldInfo Signature { 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.GetEjuserInfo().

SimultaneousLogin

Field 'simultaneous_login' in table 'ejuser': Dictionary type Bool, .NET type: short

A boolean telling if the user is counted as one of the simultaneous ones, or one who alway may log in
Declaration
public UInt16FieldInfo SimultaneousLogin { 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.GetEjuserInfo().

Sms

Field 'sms' in table 'ejuser': Dictionary type String[65], .NET type: string

The SMS number for this user
Declaration
public StringFieldInfo Sms { 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.GetEjuserInfo().

SmsMask

Field 'sms_mask' in table 'ejuser': Dictionary type Int, .NET type: int

A bitmask indicated to which extent the user should recieve sms warnings for various events.
Declaration
public Int32FieldInfo SmsMask { 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.GetEjuserInfo().

Status

Field 'status' in table 'ejuser': Dictionary type Enum, .NET type: short

The status (enum) for this user.
Declaration
public UInt16FieldInfo Status { 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.GetEjuserInfo().

Textareasize

Field 'textareasize' in table 'ejuser': Dictionary type String[32], .NET type: string

Size of textarea for each user, example '80x40'
Declaration
public StringFieldInfo Textareasize { 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.GetEjuserInfo().

TimeFormatString

Field 'time_format_string' in table 'ejuser': Dictionary type String[65], .NET type: string

Chosen time format as a string for this user
Declaration
public StringFieldInfo TimeFormatString { 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.GetEjuserInfo().

Usergroup

Field 'usergroup' in table 'ejuser': Dictionary type FK, target: Hierarchy, .NET type: int

The group this user is member of
Declaration
public Int32FieldInfo Usergroup { 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.GetEjuserInfo().

Usergroup_InnerJoin_Hierarchy

Generated join from the foreign key Usergroup in this table, to its target table HierarchyTableInfo.

Declaration
public TargetedInnerJoin<HierarchyTableInfo> Usergroup_InnerJoin_Hierarchy { get; }
Property Value
Type Description
TargetedInnerJoin<HierarchyTableInfo>
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.GetEjuserInfo().

Username

Field 'username' in table 'ejuser': Dictionary type String[64], .NET type: string

The unique username for this user.
Declaration
public StringFieldInfo Username { 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.GetEjuserInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top