Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:38
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.