Class ExtAppTableInfo

Table 'ExtApp': ExtApp list table. Applications startable from SuperOffice

Inheritance
Object
TableInfo
ExtAppTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ExtApp")]
public class ExtAppTableInfo : 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 ExtApp in the database dictionary: ExtApp

Declaration
public const string DictionaryTableName = "ExtApp"
Field Value
Type Description
String

Properties

AppType

Field 'appType' in table 'ExtApp': Dictionary type Enum, .NET type: Int16

Application type: 1 = exe, 2 = integrated html, 3 = integrated url, 4 = browser url, 5 = external url

Declaration
public FieldInfo AppType { get; }
Property Value
Type Description
FieldInfo

AvailableInState

Field 'availableInState' in table 'ExtApp': Dictionary type Enum, .NET type: AppAvailState

When should this application be available from SO: 0=always, 1=on central db, 2=on travel db,4 on satellite. The value 5 (1+4) indicates that this application is available when logged in to a central or satellite db

Declaration
public AppAvailStateFieldInfo AvailableInState { get; }
Property Value
Type Description
AppAvailStateFieldInfo

ConfigInfo

Field 'configInfo' in table 'ExtApp': Dictionary type String[2048], .NET type: String

Extra configuration information

Declaration
public StringFieldInfo ConfigInfo { 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

Deleted

Field 'deleted' in table 'ExtApp': Dictionary type UShort, .NET type: Int16

0 -> record is active 1 -> record is 'deleted' and should not be shown in lists

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

DictionaryTableNumber

Table number for table ExtApp 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

ExecuteOnEvent

Field 'executeOnEvent' in table 'ExtApp': Dictionary type Enum, .NET type: ExecuteOnEvent

Events that cause automatic execution of this app

Declaration
public ExecuteOnEventFieldInfo ExecuteOnEvent { get; }
Property Value
Type Description
ExecuteOnEventFieldInfo

ExtAppId

Field 'ExtApp_id' in table 'ExtApp': Dictionary type PK, .NET type: Int32

Primary key

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

Filename

Field 'filename' in table 'ExtApp': Dictionary type String[240], .NET type: String

Filename of the programfile

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

Icon

Field 'icon' in table 'ExtApp': Dictionary type UShort, .NET type: Int16

0 indicates default Icon (from app exe file), otherwise reference to a predefined icon resource in SO

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

LeftOuterJoin_Document_ApplicationId

Generated left outer join from the primary key ExtAppId on this table, to Document.ApplicationId.

Declaration
public TargetedLeftOuterJoin<DocumentTableInfo> LeftOuterJoin_Document_ApplicationId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocumentTableInfo>

Generated left outer join from the primary key ExtAppId on this table, to ExtAppGroupLink.ExtAppId.

Declaration
public TargetedLeftOuterJoin<ExtAppGroupLinkTableInfo> LeftOuterJoin_ExtAppGroupLink_ExtAppId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtAppGroupLinkTableInfo>

Generated left outer join from the primary key ExtAppId on this table, to ExtAppHeadingLink.ExtAppId.

Declaration
public TargetedLeftOuterJoin<ExtAppHeadingLinkTableInfo> LeftOuterJoin_ExtAppHeadingLink_ExtAppId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtAppHeadingLinkTableInfo>

Name

Field 'name' in table 'ExtApp': Dictionary type String[240], .NET type: String

The list item

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

Navigation

Field 'navigation' in table 'ExtApp': Dictionary type Enum, .NET type: Navigation

0=from menu, 1 = from Navigator(integration), 2 = From navigator

Declaration
public NavigationFieldInfo Navigation { get; }
Property Value
Type Description
NavigationFieldInfo

Parameters

Field 'parameters' in table 'ExtApp': Dictionary type String[240], .NET type: String

<template variable> <other template variable>

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

Path

Field 'path' in table 'ExtApp': Dictionary type String[240], .NET type: String

Path where the programfile is located; if empty, PATH is used

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

Rank

Field 'rank' in table 'ExtApp': Dictionary type UShort, .NET type: Int16

Rank order

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

Registered

Field 'registered' in table 'ExtApp': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'ExtApp': Dictionary type FK, .NET type: Int32

Registered by whom

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

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

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

ShowState

Field 'showState' in table 'ExtApp': Dictionary type Enum, .NET type: ShowState

Maximized / minimized / restored

Declaration
public ShowStateFieldInfo ShowState { get; }
Property Value
Type Description
ShowStateFieldInfo

Tooltip

Field 'tooltip' in table 'ExtApp': Dictionary type String[255], .NET type: String

Tooltip or other description

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

Updated

Field 'updated' in table 'ExtApp': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'ExtApp': Dictionary type FK, .NET type: Int32

Last updated by whom

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

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'ExtApp': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

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

Url1

Field 'url1' in table 'ExtApp': Dictionary type String[1024], .NET type: String

URL, supports long strings up to 1k

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

Url2

Field 'url2' in table 'ExtApp': Dictionary type String[255], .NET type: String

Obsolete - do not use this field

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

WaitToFinish

Field 'waitToFinish' in table 'ExtApp': Dictionary type Bool, .NET type: Int16

If 1, we wait synchronously for the pplication to finish before we go on

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

WindowName

Field 'windowName' in table 'ExtApp': Dictionary type String[255], .NET type: String

The window which the URL address is to open in (webpanel only)

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

Workdir

Field 'workdir' in table 'ExtApp': Dictionary type String[240], .NET type: String

Directory set to current when loading the application, if different from application's own

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)