FastEditAudits Table

Applies to QAComplete 14.3, last modified on February 19, 2024

Description

The FastEditAudits table holds a record of changes made when using the Fast Edit feature – the Move, Copy, or Clone functions. The other Fast Edit operations, like the Update Multiple Items operation, are stored in the Audit table.

Columns

The table contains the following columns:

FastEditAuditId  :  int, primary key, allows null: no

The unique numeric identifier of the Fast Edit audit record.

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time when a user used the Fast Edit feature.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DestinationFolderId  :  int, allows null: yes

If an item was copied (moved) to a folder, DestinationFolderId is the ID of the destination folder.

DestinationId  :  int, allows null: no

If a new item was created, DestinationId is the identifier of the new item.

DestinationProjId  :  int, allows null: no

The ID of the project to which an item was copied (moved).

EntityCode  :  varchar (max 100 chars), allows null: no

The code of the item that was edited.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FastEditFeature  :  varchar (max 25 chars), allows null: no

The code of the operation that was performed by using the Fast Edit feature (MOVE, COPY, CLONE).

SourceFolderId  :  int, allows null: yes

If an item was moved to a new folder, SourceFolderId is the ID of the folder that contained the item.

SourceId  :  int, allows null: no

The ID of the source item.

SourceProjId  :  int, allows null: no

The ID of the project from which an item was copied (moved).

Title  :  varchar (max 100 chars), allows null: no

The description of the performed operation or the tile of the project plan task.

UpdateUserId  :  int, allows null: no

The ID of the user who used the Fast Edit feature.

See Also

FastEditAudits View
History

Highlight search results