SqlStatistics Table

The SqlStatistics table stores database table related statistical information for user. As of AX 2009, this table is not used.

ID: 65513

Security Key: AdminTables

Method

Description

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

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

Field

ID

Type

Configuration key

Description

objectType

1

Enumeration: SqlStatType

None

userId

2

System Data Type: userId

Type: str

None

ID for the user

tabId

3

System Data Type: tableId

Type: int

None

ID for the table

indexId

4

System Data Type: indexId

Type: int

None

ID for the index

value1

5

None

value2

6

None

value3

7

None

value4

8

None

value5

9

None

value6

10

None

value7

11

None

value8

12

None

value9

13

None

value10

14

None

value11

15

None

value12

16

None

modifiedDateTime

61440

System Data Type: modifiedDateTime

Type: utcdatetime

None

dEL_ModifiedTime

61441

System Data Type: dEL_ModifiedTime

Type: int

None

modifiedBy

61442

System Data Type: modifiedBy

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Relation

Table

Lines

DataArea

DataArea Table

SqlStatistics.dataAreaId == DataArea.id

SqlStatistics

SqlStatistics Table

SqlStatistics.tabId == SqlStatistics.tabId

UserInfo

UserInfo Table

SqlStatistics.userId == UserInfo.id

Index

AllowDuplicates

Enabled

Fields

Id

No

Yes

objectType

userId

tabId

indexId

RecId

No

Yes

RecId

Use of this table might lead to an Elevation of Privileges attack or a Denial of Service attack. The Application Object Server authorizes each create, update, or 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 will be thrown.

Community Additions

ADD
Show: