Class ExtTableTableInfo
Table 'ext_table': This table contains entries used for mapping an external table to an internal table (customer or cust_company) for database integration.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ext_table")]
public class ExtTableTableInfo : 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 ExtTable in the database dictionary: ext_table
Declaration
public const string DictionaryTableName = "ext_table"
Field Value
Type | Description |
---|---|
String |
Properties
ChildTable
Field 'child_table' in table 'ext_table': Dictionary type FK, .NET type: Int32
The reference to the child table.
Declaration
public Int32FieldInfo ChildTable { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
ChildTable_InnerJoin_ExtTable
Generated join from the foreign key ChildTable in this table, to its target table ExtTableTableInfo.
Declaration
public TargetedInnerJoin<ExtTableTableInfo> ChildTable_InnerJoin_ExtTable { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ExtTableTableInfo> |
Definition
Definition of the table as described in the deployed runtime dictionary
Declaration
public override SoTable Definition { get; }
Property Value
Type | Description |
---|---|
SoTable |
Overrides
DictionaryTableNumber
Table number for table ExtTable 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 |
ExtDatasource
Field 'ext_datasource' in table 'ext_table': Dictionary type FK, .NET type: Int32
The reference to the associated datasource.
Declaration
public Int32FieldInfo ExtDatasource { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
ExtDatasource_InnerJoin_ExtDatasource
Generated join from the foreign key ExtDatasource in this table, to its target table ExtDatasourceTableInfo.
Declaration
public TargetedInnerJoin<ExtDatasourceTableInfo> ExtDatasource_InnerJoin_ExtDatasource { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ExtDatasourceTableInfo> |
ExtTableId
Field 'id' in table 'ext_table': Dictionary type PK, .NET type: Int32
The primary key (auto-incremented)
Declaration
public Int32FieldInfo ExtTableId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
LdapSearchBase2
Field 'ldap_search_base2' in table 'ext_table': Dictionary type Clob, .NET type: String
LDAP search base, multiple search bases are seperated by new line
Declaration
public StringFieldInfo LdapSearchBase2 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
LdapSearchFilter
Field 'ldap_search_filter' in table 'ext_table': Dictionary type String[256], .NET type: String
LDAP search query
Declaration
public StringFieldInfo LdapSearchFilter { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
LdapSearchResult
Field 'ldap_search_result' in table 'ext_table': Dictionary type String[256], .NET type: String
Select which data to return from LDAP
Declaration
public StringFieldInfo LdapSearchResult { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
LeftOuterJoin_ExtField_ExtTable
Generated left outer join from the primary key ExtTableId on this table, to ExtField.ExtTable.
Declaration
public TargetedLeftOuterJoin<ExtFieldTableInfo> LeftOuterJoin_ExtField_ExtTable { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<ExtFieldTableInfo> |
Name
Field 'name' in table 'ext_table': Dictionary type String[65], .NET type: String
The name for this field
Declaration
public StringFieldInfo Name { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
ParentTable
Field 'parent_table' in table 'ext_table': Dictionary type FK, .NET type: Int32
The reference to the parent table.
Declaration
public Int32FieldInfo ParentTable { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
ParentTable_InnerJoin_ExtTable
Generated join from the foreign key ParentTable in this table, to its target table ExtTableTableInfo.
Declaration
public TargetedInnerJoin<ExtTableTableInfo> ParentTable_InnerJoin_ExtTable { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ExtTableTableInfo> |
PrimaryKey
Field 'primary_key' in table 'ext_table': Dictionary type String[65], .NET type: String
The name of the primary key. TODO: depreciated?
Declaration
public StringFieldInfo PrimaryKey { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Priority
Field 'priority' in table 'ext_table': Dictionary type Int, .NET type: Int32
TODO: depreciated?
Declaration
public Int32FieldInfo Priority { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
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 |
SqlLimit
Field 'sql_limit' in table 'ext_table': Dictionary type Int, .NET type: Int32
Used for LIMIT optimiziation of the search query
Declaration
public Int32FieldInfo SqlLimit { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
SqlQuery
Field 'sql_query' in table 'ext_table': Dictionary type Clob, .NET type: String
The SQL query used for fetching the external data.
Declaration
public StringFieldInfo SqlQuery { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
SqlQuery2
Field 'sql_query2' in table 'ext_table': Dictionary type Clob, .NET type: String
The SQL query used for fetching the external data. Part 2
Declaration
public StringFieldInfo SqlQuery2 { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
Target
Field 'target' in table 'ext_table': Dictionary type Int, .NET type: Int32
Enum indicating the target table (customer or cust_company).
Declaration
public Int32FieldInfo Target { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |