Report Builder : Work Item State History : Days in State shows zero
Hello All,
We are using CLM V6.0.3 and in Report Builder, I am trying to generate a report where I am trying to calculate the difference between two dates. Precisely, I am trying to calculate the number of days by subtracting the Defect Creation date with Defect Closure date.
When I use Work Item State History, I can see a column called "Days in State", but it shows zero for all the states in the output table.
I saw a few blogs and many have complained the same issue.
Also, I understand that JRS uses SPARQL, but this query builder supports very very limited SQL commands. I tried to use DATEDIFF, YEAR, MONTH but none of it is supported. Is there any other alternate way to achieve this requirement.
Thanks
Venkatesh Prasad
2 answers
Hi all,
I built a Days In State report in a 6.0.4 environment. I can't say whether or not it would work in 6.0.3 -- I simply can't recall when the capabilities for state history were added or refined. Mine works fine. Have you considered that it is looking for days and not time? That is, if the state changed within the span of a single day, the "days in state" will be 0.
In any case, I'd be happy to share the report I have with you if you'd like to email me: asilber@us.ibm.com. It's quite a simple report where I choose Work Item Status History > Work Item.
Hope that helps,
Amy