CustomFieldValues Table

Applies to QAComplete 12.70 SaaS, last modified on January 11, 2021

Description

The CustomFieldValues table contains the values for custom fields 11 through 90 across all modules, in a one-to-one relationship. For example, each defect on the Bugs table has a corresponding record on the CustomFieldValues table where the values of the custom fields are stored.

Columns

The table contains the following columns:

CustomFieldValueId  :  int, primary key, allows null: no, default: auto generated

The unique numeric identifier of the item.

Custom11..Custom90  :  varchar (max 100 chars), allows null: yes

The values of custom fields 11 through 90.

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

The module where the custom field is used.

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

FKId  :  int, allows null: no

The ID of the related item (BugId, TestId, and so on).

See Also

CustomFields Table
Crossmodules

Highlight search results