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
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
Properties
AccessLevel
Field 'access_level' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
DateFormat
Field 'date_format' in table 'ejuser': Dictionary type Enum, .NET type: Int16
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
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
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
DbiAgentId
Field 'dbi_agent_id' in table 'ejuser': Dictionary type FK, target: DbiAgent, .NET type: Int32
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
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
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
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
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
DefaultCategory
Field 'default_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: Int32
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
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
DefaultStatusAddMessage
Field 'default_status_add_message' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: Int32
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
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
DefaultStatusNewTicket
Field 'default_status_new_ticket' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: Int32
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
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
DefaultUser
Field 'default_user' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
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
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 |
---|---|
Int32 |
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
EjuserId
Field 'id' in table 'ejuser': Dictionary type PK, .NET type: Int32
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
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
EmailMask
Field 'email_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
Flags
Field 'flags' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
IdleTime
Field 'idle_time' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
LastCategory
Field 'last_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: Int32
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
LoginAttempts
Field 'login_attempts' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
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
MinuteOffset
Field 'minute_offset' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
NewGui
Field 'new_gui' in table 'ejuser': Dictionary type Bool, .NET type: Int16
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
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
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
NotifyMask
Field 'notify_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
NumExpandedMessages
Field 'num_expanded_messages' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
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
PictureId
Field 'picture_id' in table 'ejuser': Dictionary type FK, target: Attachment, .NET type: Int32
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
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
ProfileId
Field 'profile_id' in table 'ejuser': Dictionary type FK, target: Profile, .NET type: Int32
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
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
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
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
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
SimultaneousLogin
Field 'simultaneous_login' in table 'ejuser': Dictionary type Bool, .NET type: Int16
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
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
SmsMask
Field 'sms_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32
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
Status
Field 'status' in table 'ejuser': Dictionary type Enum, .NET type: Int16
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
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
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
Usergroup
Field 'usergroup' in table 'ejuser': Dictionary type FK, target: Hierarchy, .NET type: Int32
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
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
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