Class ConfigTableInfo

Table 'config': This table contains certain system-wide configuration values.

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

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

Properties

AdminMail

Field 'admin_mail' in table 'config': Dictionary type String[256], .NET type: String

The email address to the administrator of the system. E.g. ejournal-admin@company.com.

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

AttachmentPath

Field 'attachment_path' in table 'config': Dictionary type String[256], .NET type: String

The path to the folder containing the attachments.

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

Autologout

Field 'autologout' in table 'config': Dictionary type Int, .NET type: Int32

The number of minutes if idle time before a user is logged ut. A zero value means no autologout.

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

CgiBin

Field 'cgi_bin' in table 'config': Dictionary type String[256], .NET type: String

The cgi-bin alias used to access the executables through HTTP. E.g. '/bin'

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

CgiUrl

Field 'cgi_url' in table 'config': Dictionary type String[256], .NET type: String

The base URL to the system. E.g. 'http://ejournal.company.com'.

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

CgiUrlInternal

Field 'cgi_url_internal' in table 'config': Dictionary type String[256], .NET type: String

The internal base URL to the system. E.g. 'http://ejournal.company.com'.

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

ConfigId

Field 'id' in table 'config': Dictionary type PK, .NET type: Int32

The primary key (auto-incremented)

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

DebugFlags

Field 'debug_flags' in table 'config': Dictionary type Int, .NET type: Int32

A default bitmask of flags controlling debug logging.

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

DefaultMail

Field 'default_mail' in table 'config': Dictionary type String[256], .NET type: String

The default from address in emails being sent from the system. E.g. support@company.com.

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

FeatureToggle

Field 'feature_toggle' in table 'config': Dictionary type Clob, .NET type: String

Temporary values used for feature toggles

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

Flags

Field 'flags' in table 'config': Dictionary type Int, .NET type: Int32

A bitmask of flags controlling various options.

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

GfxUrl

Field 'gfx_url' in table 'config': Dictionary type String[256], .NET type: String

The base URL to the graphics files.

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

InstalledAt

Field 'installed_at' in table 'config': Dictionary type DateTime, .NET type: DateTime

The timestamp of when the system was installed, or last upgraded.

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

InstalledBy

Field 'installed_by' in table 'config': Dictionary type String[256], .NET type: String

Whoever installed the software.

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

Language

Field 'language' in table 'config': Dictionary type String[6], .NET type: String

The systemlanguage. 'no' or 'en'.

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

Mailheader

Field 'mailheader' in table 'config': Dictionary type String[256], .NET type: String

The default header used (i.e. line 1) in outbound email.

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

MbMaxValue

Field 'mb_max_value' in table 'config': Dictionary type Int, .NET type: Int32

This is the upper (initial) value for the spam-control algorithm, which makes sure that a single email address does not recieve too many emails.

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

MbModifier

Field 'mb_modifier' in table 'config': Dictionary type Int, .NET type: Int32

This is the 'cost' of sending an email, which is subtracted from the mb-value for the given email address. The mb-value is increased with 1 every second.

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

MbThreshold

Field 'mb_threshold' in table 'config': Dictionary type Int, .NET type: Int32

This is the treshold value for the spam-contol algorithm. When the value for a given email address is below this value, emails will be blocked.

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

PanicMail

Field 'panic_mail' in table 'config': Dictionary type String[256], .NET type: String

The email address to where error messages are sent. Normally error@superoffice.com.

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

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

Simautologout

Field 'simautologout' in table 'config': Dictionary type Int, .NET type: Int32

The number of minutes if idle time before a simultaneus user is logged ut. A zero value means no autologout.

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

SmtpHost

Field 'smtp_host' in table 'config': Dictionary type String[256], .NET type: String

The hostname or IP-address of the SMTP server used for sending email.

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

SmtpPort

Field 'smtp_port' in table 'config': Dictionary type Int, .NET type: Int32

The port of the SMTP server used for sending email.

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

Tag

Field 'tag' in table 'config': Dictionary type String[33], .NET type: String

The tag used as ticket id identificator in the subject of emails.

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

TemplatePath

Field 'template_path' in table 'config': Dictionary type String[256], .NET type: String

The path to the templates used for the customer front-end.

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

TempLicense

Field 'temp_license' in table 'config': Dictionary type String[256], .NET type: String

Temporary license key created for this session.

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

TextPath

Field 'text_path' in table 'config': Dictionary type String[256], .NET type: String

The path to the text-folder containing the emailBackup, trashbin, etc. subfolders.

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

UniqueId

Field 'unique_id' in table 'config': Dictionary type String[33], .NET type: String

An ID that should be unique for all eJournal installations.

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

Version

Field 'version' in table 'config': Dictionary type String[33], .NET type: String

The version of the installed software.

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

Warning

Field 'warning' in table 'config': Dictionary type String[256], .NET type: String

The path + leading filename for the warning logfiles.

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)