TaskTemplates View

Applies to QAComplete 12.80 SaaS, last modified on April 19, 2021

Description

Contains information on task templates.

Dependencies

Columns

DateCreated  :  datetime, allows null: no

The date and time the item was created.

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

DateUpdated  :  datetime, allows null: no

The date and time the item was last updated.

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

DeptId  :  int, allows null: no

The ID of the department that owns the task template.

Description  :  varchar (max 1000 chars), allows null: yes

The description of the task template.

This column corresponds to a field that can be available for Rich Text Feature.

IsCompanyWide  :  varchar (max 1 char), allows null: no

Indicates whether the task template is company-wide.

IsPublic  :  char (max 1 char), allows null: yes

Indicates whether the task template is public.

NbrEvents  :  int, allows null: yes

The number of events attached to the associated item.

NbrFiles  :  int, allows null: yes

The number of files attached to the associated item.

NbrNotes  :  int, allows null: yes

The number of notes attached to the associated item.

NbrTasks  :  int, allows null: yes

The number of tasks attached to the associated item.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

TaskTemplateId  :  int, allows null: no

The unique numeric identifier of the task template.

TaskTemplateName  :  varchar (max 50 chars), allows null: no

The name of the task template.

UpdateUserId  :  int, allows null: no

The ID of the user who last updated the item.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who last updated the associated item, in the Last name, First name format.

See Also

TaskTemplates Table
Project Management

Highlight search results