Modify the Number of Work Item Fields Limit Per Data Type

You can alter the number of Work Item Fields used for a Repository.

The table SKWorkItemFieldTypeCounts stores the column count for each data type (number, decimal, string, and datetime) supported by Work Item fields. The count for each data type can be varied in the column ColumnCount of this table.

Based on the SKWorkItemFieldTypeCounts table, mapping field gets filled in SKWorkItemFieldsDefinition table when you create a Work Item field from the process designer settings menu.

Consider that you want to increase the string type by one column. That is, currently you can have 18 string Work Item fields and you want to have 19 string Work Item fields. Complete the following steps to increase the string type:

1. In SKWorkItemFieldTypeCounts table, increase the count to 19 from 18 for the string type.

2. Add the column nvarchar19 in the SKWorkItemFields table. SKWorkitemfields table contains all the runtime value details of Work Item fields used in an activity.

3. In the Process Designer, create a new string type Work Item field.

4. The created Work Item field can be used in activities by setting it from the Property "Set Workitemfields".