Class ElementProfileTableInfo

Table 'element_profile': The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link

Inheritance
Object
TableInfo
ElementProfileTableInfo
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

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

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 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

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

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

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 shown

Declaration
public StringFieldInfo FilterField { get; }
Property Value
Type Description
StringFieldInfo

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 shown

Declaration
public StringFieldInfo FilterValue { get; }
Property Value
Type Description
StringFieldInfo

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>

Name

Field 'name' in table 'element_profile': Dictionary type String[256], .NET type: String

This is the name used by common profiles

Declaration
public StringFieldInfo Name { get; }
Property Value
Type Description
StringFieldInfo

OwnedByUser

Field 'owned_by_user' in table 'element_profile': Dictionary type FK, .NET type: Int32

The id of the user.

Declaration
public Int32FieldInfo OwnedByUser { get; }
Property Value
Type Description
Int32FieldInfo

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>

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.h

Declaration
public UInt16FieldInfo ProfileType { get; }
Property Value
Type Description
UInt16FieldInfo

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

ScreenDefinitionElement

Field 'screen_definition_element' in table 'element_profile': Dictionary type FK, .NET type: Int32

The id of the screen_definition_element.

Declaration
public Int32FieldInfo ScreenDefinitionElement { get; }
Property Value
Type Description
Int32FieldInfo

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>

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)