Join Wintertainment 2021 to share your stories, have fun, earn community badges, and more!

TaskTemplates View

Applies to QAComplete 12.94 SaaS, last modified on December 06, 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