Class LogEventsTableInfo

Table 'log_events': System log

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

Declaration
public const string DictionaryTableName = "log_events"
Field Value
Type Description
System.String

Properties

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 LogEvents 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
System.Int32

EventGroup

Field 'event_group' in table 'log_events': Dictionary type Int, .NET type: System.Int32

See NewLog::EventGroup

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

EventId

Field 'event_id' in table 'log_events': Dictionary type Int, .NET type: System.Int32

See NewLog::EventId

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

EventType

Field 'event_type' in table 'log_events': Dictionary type Int, .NET type: System.Int32

Notification=1, warning=2, error=3, critical error=4

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

LogEventsId

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

Primary key

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

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

SourceUser

Field 'source_user' in table 'log_events': Dictionary type Int, .NET type: System.Int32

The user generating the event. 1=system, other=ejuser.id

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

SourceUserDesc

Field 'source_user_desc' in table 'log_events': Dictionary type Clob, .NET type: System.String

Describing the id in source_user. eg user name or customer name or (System)

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

TargetId

Field 'target_id' in table 'log_events': Dictionary type Int, .NET type: System.Int32

The id of the target entity (ticket.id, customer.id etc)

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

TimeOfEvent

Field 'time_of_event' in table 'log_events': Dictionary type DateTime, .NET type: System.DateTime

When did the event take place

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

Var1

Field 'var1' in table 'log_events': Dictionary type Clob, .NET type: System.String

Dynamic info

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

Var2

Field 'var2' in table 'log_events': Dictionary type Clob, .NET type: System.String

Dynamic info

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

Var3

Field 'var3' in table 'log_events': Dictionary type Clob, .NET type: System.String

Dynamic info

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

Var4

Field 'var4' in table 'log_events': Dictionary type Clob, .NET type: System.String

Dynamic info

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

Var5

Field 'var5' in table 'log_events': Dictionary type Clob, .NET type: System.String

Dynamic info

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

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)