SysDataBaseLog Table

Stores database log entry per operation type( like insert,update,delete) per table with old and new values for the table columns stored in a container in the data field of the table. This information is stored per company.

ID: 943

Configuration Key: SysDatabaseLog

Security Key: AdminTables

Methods

Method

Description

aosValidateDelete

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

caption

(Inherited from xRecord.)

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

clear

(Inherited from xRecord.)

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

contents2Str

context

(Inherited from xRecord.)

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

delete

(Inherited from xRecord.)

disableCache

(Inherited from xRecord.)

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

getDataAslist

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

helpField

(Inherited from xRecord.)

initValue

(Inherited from xRecord.)

insert

isFormDataSource

(Inherited from xRecord.)

isTmp

(Inherited from xRecord.)

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

merge

(Inherited from xRecord.)

modifiedField

(Inherited from xRecord.)

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

postLoad

(Inherited from xRecord.)

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

renamePrimaryKey

(Inherited from xRecord.)

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setDescription

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

suppressWarnings

(Inherited from xRecord.)

tableName

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

update

(Inherited from xRecord.)

usageCount

(Inherited from xRecord.)

validateDelete

(Inherited from xRecord.)

validateField

(Inherited from xRecord.)

validateWrite

(Inherited from xRecord.)

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

write

(Inherited from xRecord.)

xml

(Inherited from xRecord.)

Fields

Field

ID

Type

Configuration key

Description

Username

1

Extended Data Type: UserName

Type: str

SysSign

User name associated with user ID at time of logging.

Description

2

Extended Data Type: Description

Type: str

None

Brief description of transaction.

LogType

3

Enumeration: DatabaseLogType

None

Type of log create/update or delete.

Data

4

Extended Data Type: Blobdata

Type: container

None

Container for storing Blob data

table

5

Extended Data Type: RefTableId

Type: int

None

Table the transaction refers to.

LogRecId

6

Extended Data Type: RefRecId

Type: int64

None

Reference field in a different table.

createdDateTime

61444

System Data Type: createdDateTime

Type: utcdatetime

None

dEL_CreatedTime

61445

System Data Type: dEL_CreatedTime

Type: int

None

createdBy

61446

System Data Type: createdBy

Type: str

None

createdTransactionId

61447

System Data Type: createdTransactionId

Type: int64

None

dataAreaId

61448

System Data Type: dataAreaId

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Groups

Field Group

Fields

All

Description

LogType

Data

table

LogRecId

Username

AutoReport

LogType

Description

Username

Relations

Relation

Table

Lines

DataArea

DataArea Table

SysDataBaseLog.dataAreaId == DataArea.id

Relation1

Common Table

SysDataBaseLog.LogRecId == Common.RecId

Indexes

Index

AllowDuplicates

Enabled

Fields

RecId

No

Yes

RecId

TableRecIdIdx

Yes

Yes

table

LogRecId

createdDateTime

Security Note

Use of this table might lead to an Elevation of Privileges attack or a Denial of Service attack. Therefore, the AOSAuthorization property is set to UpdateDelete. The Application Object Server authorizes each update and delete action on the table by confirming that the current user has permission to perform the requested operation on that table. If the user who initiates the operation is not authorized to perform the operation, an exception is thrown.

See Also

Table Methods

Tables Overview