How can I manually change the grouping rules for my list of values in the Severity field to group by defect type?

0 Likes

Problem:

How can I manually change the grouping rules for my list of values in the Severity field to group by defect type?

Resolution:

ANSWER
----------------------------------
When working with Issue Manager a situation may arise where changing the grouping rule for the Severity field is necessary. The grouping rule can normally be changed in Issue Manager by navigating to the following section:

[Issue Manager | Configuration | Customization | List of Values | Severities]

The grouping rules for fields is defined by the "List Grouping" option which you can see below:




However, you can see from the image that the List Grouping value is "greyed out", meaning it cannot be changed. The List Grouping can only be changed when the list of values is empty. In some situations, this value may be set to "Not Grouped". If it is to be changed to "By Defect Type" then the list of values must first be deleted and made empty. However, this will have an impact on the existing issues that have made use of the Severity list.

To change the list grouping without emptying the list of values you must have software installed that can modify database files, such as Microsoft SQL Enterprise Manager, and then take the following steps:

  • Open the SilkCentral Issue Manager database file.
  • Open the table called LOV_List.
  • Find Severities in the table, and change the values of "GroupListID" for Severities from 0 (the ID for Not Grouped) to 9000 (the ID for By Defect Type).

    After making this change to the database, the Severities list should display its list of values according to the defect type assigned to the issue.

Old KB# 23766
Comment List
Anonymous
Related Discussions
Recommended