Defect Module Column Standardization in Template

  • Questions
  • Defect Module Column Standardization in Template
Question ID: 107783
0
0

I want to make a standard view and order for the defect module columns that display in our template that we use to create new projects. I still want the users to be able to add additional columns that are within the project that is not shown in our standard view. The only way we can see to make this possible is to forcibly hide the columns within the admin-side of the project. This removes the ability for the user to customize the Defects module to add or remove columns because they no longer exist for them. Is there any way around this?

Marked as spam
Posted by (Questions: 192, Answers: 1)
Asked on July 27, 2017 4:00 pm
5 views
Answers
0
Private answer

I found this on the HPE Knowledge base:
https://community.hpe.com/t5/Quality-Center-ALM-Practitioners/Re-Setting-a-default-grid-view-for-all-users-in-Defect-Manager/m-p/6564322#M87722

I followed this post to the end and found the 2 step solution and tested it on my test environment.
So, here are the steps:

1. Login to a project and modify the defect module view as desired. Then, login to Site Administration; select the project you just modified and go to the COMMON_SETTINGS table and perform the following SQL query:

UPDATE COMMON_SETTINGS SET CSET_OWNER='__default__'
where CSET_CATEGORY='DefectsModule-000000004243046514'
AND CSET_OWNER=xxxxxx

where xxxxxx is the user name that you changed the Defect Module view.

2. In the template you are using to create new projects, go to Customization Workflow and change the CanLogin function as follows:
Function CanLogin(DomainName, ProjectName, UserName)
On Error Resume Next

Set cs = TDConnection.CommonSettings
Set us = TDConnection.UserSettings
cs.Open ''DefectsModule-000000004243046514''
us.Open ''DefectsModule-000000004243046514''
If us.Value(''ModuleState'') = '''' Then
us.Value(''ModuleState'') = cs.value(''ModuleState'')
End If

cs.Close
us.Post
us.Close
Set us = Nothing
Set cs = Nothing

CanLogin = DefaultRes
On Error GoTo 0
End Function

and Save this code.

Now, when you create create a new project from this template, the Workflow code will be there.
So, after creating a new project from the template, you will still have to perform step 1, but each time you login the Defect Module view should be what you want.

Now, I must add that this solution is not officially supported by HPE or Orasi but I did test it myself and it should decrease the amount of time you use to get the Defect Module view you want for new projects.

Marked as spam
Posted by (Questions: 1, Answers: 206)
Answered on July 27, 2017 4:02 pm