TitleForLists Table

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

Description

The table stores values used to generate titles for list items. QAComplete uses titles to show list items in the Traceability (Show Linked Items mode.

Columns

The table contains the following columns:

TitleId  :  int, primary key, allows null: no

The unique numeric identifier of the item.

DateUpdated  :  datetime, allows null: yes

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

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

List identifier: the name of the related list without spaces.

UpdateUserId  :  int, allows null: yes

The ID of the user who last updated the item.

Value1  :  varchar (max 2000 chars), allows null: yes

Stores the symbols used as a prefix.

Value2  :  varchar (max 2000 chars), allows null: yes

The identifier of the first field (ListId, Field1, Field2, and so on), the value of which is used to construct the title of the list item.

Value3  :  varchar (max 2000 chars), allows null: yes

The symbols that are used as the first separator.

Value4  :  varchar (max 2000 chars), allows null: yes

The identifier of the second field (ListId, Field1, Field2, and so on), the value of which is used to construct the title of the list item.

Value5  :  varchar (max 2000 chars), allows null: yes

The symbols that are used as the second separator.

Value6  :  varchar (max 2000 chars), allows null: yes

The identifier of the third field (ListId, Field1, Field2, and so on), the value of which is used to construct the title of the list item.

Value7  :  varchar (max 2000 chars), allows null: yes

The symbols that are used as the suffix.

See Also

TitleForLists View
Lists

Highlight search results