Defect aging assistance

Question ID: 110064
0
0

Hey, we currently have the ability to create an aging report in ALM but it’s not detailed enough for our needs. Can we get some help creating a field in defects that will provide us the number of days between when a defect is opened to closed? I have already created a user-defined field called Aging.

Marked as spam
Posted by (Questions: 106, Answers: 8)
Asked on February 10, 2021 5:02 pm
7 views
Answers (1)
0
Private answer

Here is the workflow for the aging field that will auto-populate the age.

'this workflow calculates the age of a defect using the system date if no closing date is available

On Error Resume Next
StrFoundDate = Bug_Fields.Field("BG_DETECTION_DATE").Value
StrCloseDate = Bug_Fields.Field("BG_CLOSING_DATE").Value

If Bug_Fields.Field("BG_CLOSING_DATE").IsNull Then
StrCloseDate = Date
Bug_Fields.Field("BG_USER_##").Value = DateDiff("d",StrFoundDate,StrCloseDate) + 1
Else
Bug_Fields.Field("BG_USER_##").Value = DateDiff("d",StrFoundDate,StrCloseDate) + 1
End If

On Error GoTo 0

'This is the end of the aging workflow

The only change that should need to be made is to...

Bug_Fields.Field("BG_USER_##").Value = DateDiff("d",StrFoundDate,StrCloseDate) + 1

The "BG_USER_##" will need to be changed to the user-defined field that you will store the number of days in.

Marked as spam
Posted by (Questions: 0, Answers: 300)
Answered on February 10, 2021 5:05 pm