Export (0) Print
Expand All

EventCUD Table

The EventCUD table is used for changed based alerts only: When a user creates/updates/deletes a record the information regarding that event is stored in this table. Records in this table are inserted by the hooks for the database log created/update/delete events, and are deleted later by the CUD event processor after CUD records have been matched against rules.

ID: 288

Configuration Key: Event

Security Key: BasicTables

Method

Description

alertBuffer

aosValidateDelete

(Inherited from xRecord.)

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

context

(Inherited from xRecord.)

cudRecCaption

cudTablelabel

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

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

(Inherited from xRecord.)

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

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

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

::Find

Field

ID

Type

Configuration key

Description

CompanyId

1

System Data Type: selectableDataArea

Type: str

None

ID for the company you can select

CudTableId

2

Extended Data Type: EventCudTableId

Type: int

None

Table ID of the CUD event table.

CudRecId

3

Extended Data Type: EventRefRecId

Type: int64

None

Reference field in a different table.

Event

4

Enumeration: EventLogType

None

Type of event create/update or delete.

Data

5

Extended Data Type: Blobdata

Type: container

None

Container for storing Blob data

KeyFieldList

6

Extended Data Type: EventFieldList

Type: container

None

Packed list of field IDs.

KeyFieldData

7

Extended Data Type: EventFieldData

Type: container

None

Packed map of field data.

Status

8

Enumeration: BatchStatus

None

Current status of the job

SessionId

9

Extended Data Type: SessionId

Type: int

None

ID for the current session.

DEL_SessionLoginDate

10

Extended Data Type: StartDate

Type: date

SysDeletedObjects41

Start date of period.

DEL_SessionLoginTime

11

System Data Type: timeOfDay

Type: int

SysDeletedObjects41

Time of day

PreviousRecord

12

Extended Data Type: Blobdata

Type: container

None

Container for storing Blob data

SessionLoginDateTime

18

Extended Data Type: SessionLoginDateTime

Type: utcdatetime

None

Login date and time for the session.

UserId

19

System Data Type: userId

Type: str

None

ID for the user

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

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Group

Fields

AutoReport

Status

Event

cudTablelabel

CompanyId

Identification

Status

Event

cudTablelabel

CompanyId

UserId

Session

SessionId

SessionLoginDateTime

System

CudRecId

CudTableId

Relation

Table

Lines

Common

Common Table

EventCUD.CudTableId == Common.TableId

CudRecId

Common Table

EventCUD.CudRecId == Common.RecId

DataArea

DataArea Table

EventCUD.dataAreaId == DataArea.id

UserInfo

UserInfo Table

EventCUD.UserId == UserInfo.id

Index

AllowDuplicates

Enabled

Fields

RecId

No

Yes

RecId

StatusIdx

Yes

Yes

Status

createdDateTime

Community Additions

ADD
Show:
© 2014 Microsoft