Defect aging assistance
« Back
Tags:
Category:
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: 113, Answers: 8)
Asked on February 10, 2021 5:02 pm
38 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: 309)
Answered on February 10, 2021 5:05 pm
« Back
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

Got it!
X
Scroll to Top