Class EjuserTableInfo
Table 'ejuser': This table contains entries for the users of the system.
Implements
Inherited Members
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 agentDeclaration
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 userDeclaration
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 userDeclaration
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 ownerDeclaration
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
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().
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 successDeclaration
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 passwordDeclaration
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 notDeclaration
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 ejuserDeclaration
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 inDeclaration
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 userDeclaration
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 userDeclaration
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 ofDeclaration
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().