Class ScreenDefinitionElementTableInfo
Table 'screen_definition_element': An element in a configurable screen
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("screen_definition_element")]
public class ScreenDefinitionElementTableInfo : 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.GetScreenDefinitionElementInfo().
Fields
DictionaryTableName
Conceptual name of table ScreenDefinitionElement in the database dictionary: screen_definition_element
Declaration
public const string DictionaryTableName = "screen_definition_element"
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.GetScreenDefinitionElementInfo().
Properties
BaseTable
Field 'base_table' in table 'screen_definition_element': Dictionary type String[256], .NET type: string
Name of the table used as a base for element profile configurationDeclaration
public StringFieldInfo BaseTable { 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.GetScreenDefinitionElementInfo().
CreationScript
Field 'creation_script' in table 'screen_definition_element': Dictionary type Clob, .NET type: string
The script used to create this elementDeclaration
public StringFieldInfo CreationScript { 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.GetScreenDefinitionElementInfo().
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.GetScreenDefinitionElementInfo().
Description
Field 'description' in table 'screen_definition_element': Dictionary type String[256], .NET type: string
A description of this fieldDeclaration
public StringFieldInfo Description { 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.GetScreenDefinitionElementInfo().
DictionaryTableNumber
Table number for table ScreenDefinitionElement 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.GetScreenDefinitionElementInfo().
ElementType
Field 'element_type' in table 'screen_definition_element': Dictionary type Enum, .NET type: short
An enum for which HtmlElement type this is.Declaration
public UInt16FieldInfo ElementType { 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.GetScreenDefinitionElementInfo().
Hide
Field 'hide' in table 'screen_definition_element': Dictionary type Bool, .NET type: short
If TRUE the element will be hidden from the userDeclaration
public UInt16FieldInfo Hide { 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.GetScreenDefinitionElementInfo().
LeftOuterJoin_ElementProfile_ScreenDefinitionElement
Generated left outer join from the primary key ScreenDefinitionElementId on this table, to ElementProfile.ScreenDefinitionElement.
Declaration
public TargetedLeftOuterJoin<ElementProfileTableInfo> LeftOuterJoin_ElementProfile_ScreenDefinitionElement { 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.GetScreenDefinitionElementInfo().
Name
Field 'name' in table 'screen_definition_element': Dictionary type String[256], .NET type: string
A name (handle) for this element.Declaration
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 TablesInfo.GetScreenDefinitionElementInfo().
OrderPos
Field 'order_pos' in table 'screen_definition_element': Dictionary type Int, .NET type: int
The sorted position of this screen in this chooserDeclaration
public Int32FieldInfo OrderPos { 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.GetScreenDefinitionElementInfo().
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.GetScreenDefinitionElementInfo().
ScreenDefinition
Field 'screen_definition' in table 'screen_definition_element': Dictionary type FK, target: ScreenDefinition, .NET type: int
The screen-definition this element belongs toDeclaration
public Int32FieldInfo ScreenDefinition { 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.GetScreenDefinitionElementInfo().
ScreenDefinitionElementId
Field 'id' in table 'screen_definition_element': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo ScreenDefinitionElementId { 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.GetScreenDefinitionElementInfo().
ScreenDefinition_InnerJoin_ScreenDefinition
Generated join from the foreign key ScreenDefinition in this table, to its target table ScreenDefinitionTableInfo.
Declaration
public TargetedInnerJoin<ScreenDefinitionTableInfo> ScreenDefinition_InnerJoin_ScreenDefinition { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ScreenDefinitionTableInfo> |
Remarks
An instance of this class represents one instance of this table in an SQL statement. In most
cases each table appears only once in a SELECT, but in cases where you need to self-join, or
there are multiple 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.GetScreenDefinitionElementInfo().