Class ElementProfileTableInfo
Table 'element_profile': The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("element_profile")]
public class ElementProfileTableInfo : 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 ElementProfile in the database dictionary: element_profile
Declaration
public const string DictionaryTableName = "element_profile"
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
Config
Field 'config' in table 'element_profile': Dictionary type Clob, .NET type: String
The actual profile data. Each HtmlElement may choose format. Normally XML.Declaration
public StringFieldInfo Config { 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
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 ElementProfile 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
ElementProfileId
Field 'id' in table 'element_profile': Dictionary type PK, .NET type: Int32
The primary key (auto-incremented)Declaration
public Int32FieldInfo ElementProfileId { 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
ElementType
Field 'element_type' in table 'element_profile': Dictionary type Enum, .NET type: Int16
What kind of element is this? Static, blogic or extra table?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
FilterField
Field 'filter_field' in table 'element_profile': Dictionary type String[255], .NET type: String
Name of field, if any, that is used to filter which profiles should be shownDeclaration
public StringFieldInfo FilterField { 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
FilterValue
Field 'filter_value' in table 'element_profile': Dictionary type String[255], .NET type: String
If filter_field is set, then this field is the value that is used to filter which profiles should be shownDeclaration
public StringFieldInfo FilterValue { 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_RoleElement_ElementProfile
Generated left outer join from the primary key ElementProfileId on this table, to RoleElement.ElementProfile.
Declaration
public TargetedLeftOuterJoin<RoleElementTableInfo> LeftOuterJoin_RoleElement_ElementProfile { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<RoleElementTableInfo> |
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 'element_profile': Dictionary type String[256], .NET type: String
This is the name used by common profilesDeclaration
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
OwnedByUser
Field 'owned_by_user' in table 'element_profile': Dictionary type FK, target: Ejuser, .NET type: Int32
The id of the user.Declaration
public Int32FieldInfo OwnedByUser { 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
OwnedByUser_InnerJoin_Ejuser
Generated join from the foreign key OwnedByUser in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> OwnedByUser_InnerJoin_Ejuser { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<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
ProfileType
Field 'profile_type' in table 'element_profile': Dictionary type Enum, .NET type: Int16
Enum indicating whether this is the default profile (only one), user profile or a common profile. Defined in Profile.hDeclaration
public UInt16FieldInfo ProfileType { 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
ScreenDefinitionElement
Field 'screen_definition_element' in table 'element_profile': Dictionary type FK, target: ScreenDefinitionElement, .NET type: Int32
The id of the screen_definition_element.Declaration
public Int32FieldInfo ScreenDefinitionElement { 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
ScreenDefinitionElement_InnerJoin_ScreenDefinitionElement
Generated join from the foreign key ScreenDefinitionElement in this table, to its target table ScreenDefinitionElementTableInfo.
Declaration
public TargetedInnerJoin<ScreenDefinitionElementTableInfo> ScreenDefinitionElement_InnerJoin_ScreenDefinitionElement { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ScreenDefinitionElementTableInfo> |
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
StaticElement
Field 'static_element' in table 'element_profile': Dictionary type Enum, .NET type: Int16
An enum for which HtmlElement this is. All profileable elements in static screens has a unique enum matching this one.Declaration
public UInt16FieldInfo StaticElement { 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