Class DbiAgentTableInfo
Table 'dbi_agent': DBI agent settings
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("dbi_agent")]
public class DbiAgentTableInfo : 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 DbiAgent in the database dictionary: dbi_agent
Declaration
public const string DictionaryTableName = "dbi_agent"
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
DbiAgentId
Field 'id' in table 'dbi_agent': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
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
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
DictionaryTableNumber
Table number for table DbiAgent 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
IdString
Field 'id_string' in table 'dbi_agent': Dictionary type String[256], .NET type: String
A field for an id_string which may be used to access the dbi agentDeclaration
public StringFieldInfo IdString { 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_Attachment_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Attachment.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<AttachmentTableInfo> LeftOuterJoin_Attachment_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<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
LeftOuterJoin_Contact_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Contact.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<ContactTableInfo> LeftOuterJoin_Contact_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ContactTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_DbiAgentField_AgentId
Generated left outer join from the primary key DbiAgentId on this table, to DbiAgentField.AgentId.
Declaration
public TargetedLeftOuterJoin<DbiAgentFieldTableInfo> LeftOuterJoin_DbiAgentField_AgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<DbiAgentFieldTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_DbiAgentSchedule_AgentId
Generated left outer join from the primary key DbiAgentId on this table, to DbiAgentSchedule.AgentId.
Declaration
public TargetedLeftOuterJoin<DbiAgentScheduleTableInfo> LeftOuterJoin_DbiAgentSchedule_AgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<DbiAgentScheduleTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_EabEntry_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to EabEntry.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<EabEntryTableInfo> LeftOuterJoin_EabEntry_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EabEntryTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_Ejuser_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Ejuser.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<EjuserTableInfo> LeftOuterJoin_Ejuser_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EjuserTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_Email_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Email.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<EmailTableInfo> LeftOuterJoin_Email_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<EmailTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to KbCategory.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<KbCategoryTableInfo> LeftOuterJoin_KbCategory_DbiAgentId { 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_KbEntry_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to KbEntry.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<KbEntryTableInfo> LeftOuterJoin_KbEntry_DbiAgentId { 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_KbEntryComment_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to KbEntryComment.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<KbEntryCommentTableInfo> LeftOuterJoin_KbEntryComment_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<KbEntryCommentTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_KbGroup_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to KbGroup.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<KbGroupTableInfo> LeftOuterJoin_KbGroup_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<KbGroupTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_Person_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Person.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<PersonTableInfo> LeftOuterJoin_Person_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<PersonTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
LeftOuterJoin_SList_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to SList.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<SListTableInfo> LeftOuterJoin_SList_DbiAgentId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<SListTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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_DbiAgentId
Generated left outer join from the primary key DbiAgentId on this table, to Ticket.DbiAgentId.
Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_DbiAgentId { 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
Name
Field 'name' in table 'dbi_agent': Dictionary type String[256], .NET type: String
Agent nameDeclaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple occurrences for other reasons (typically additional restrictions in the joins),
then you will need multiple instances.
Instances of this class are created by calling
Path
Field 'path' in table 'dbi_agent': Dictionary type String[256], .NET type: String
Path to agent URL or file pathDeclaration
public StringFieldInfo Path { 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
Protocol
Field 'protocol' in table 'dbi_agent': Dictionary type Enum, .NET type: Int16
Agent communcication protocolDeclaration
public UInt16FieldInfo Protocol { 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
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