Show / Hide Table of Contents

Class ConfigTableInfo

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

Inheritance
object
TableInfo
ConfigTableInfo
Implements
ICloneable
Inherited Members
TableInfo.ToString()
TableInfo.RegisterFields(params FieldInfo[])
TableInfo.FieldInfoFromSoField(SoField)
TableInfo.Clone()
TableInfo.IsSameTable(TableInfo)
TableInfo.FindField(string)
TableInfo.ProtAll
TableInfo.HashCheckFields
TableInfo.TableName
TableInfo.DbName
TableInfo.IsDictionaryTable
TableInfo.All
TableInfo.this[string]
TableInfo.PrimaryKeyField
object.Equals(object)
object.Equals(object, object)
object.ReferenceEquals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
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 TablesInfo.GetConfigInfo().

Fields

DictionaryTableName

Conceptual name of table Config in the database dictionary: config

Declaration
public const string DictionaryTableName = "config"
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

Autologout

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

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

ConfigId

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

The primary key (auto-incremented)
Declaration
public Int32FieldInfo ConfigId { 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.GetConfigInfo().

DebugFlags

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

A default bitmask of flags controlling debug logging.
Declaration
public Int32FieldInfo DebugFlags { 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.GetConfigInfo().

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
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.GetConfigInfo().

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides
TableInfo.Definition
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

Flags

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

A bitmask of flags controlling various options.
Declaration
public Int32FieldInfo Flags { 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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

MbMaxValue

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

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
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.GetConfigInfo().

MbModifier

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

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
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.GetConfigInfo().

MbThreshold

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

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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.GetConfigInfo().

Simautologout

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

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
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.GetConfigInfo().

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
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.GetConfigInfo().

SmtpPort

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

The port of the SMTP server used for sending email.
Declaration
public Int32FieldInfo SmtpPort { 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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

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
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.GetConfigInfo().

Implements

ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)
Converters.MapEnums<From, To>(From)
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top