RQM- Elapsed date when a new defect is raised
I would like to know if there is any way to determine the time that has elapsed since a Defect was raised.
or Is it possible to customize this in some way that Due Date-Creation Date = the time that has elapsed and which is spent working on a Defect.
We did find a way, which consists of exporting these records to Excel, and applying a formula to subtract the dates. However, the problem with this solution is that because of the date format above (Sep 22, 2011 11:12:04 a.m. for example) we cannot format the dates in Excel in order to subtract them.
or Is it possible to customize this in some way that Due Date-Creation Date = the time that has elapsed and which is spent working on a Defect.
We did find a way, which consists of exporting these records to Excel, and applying a formula to subtract the dates. However, the problem with this solution is that because of the date format above (Sep 22, 2011 11:12:04 a.m. for example) we cannot format the dates in Excel in order to subtract them.
One answer
In RQM 2.x, you could use the RQM Reportable REST API (https://jazz.net/wiki/bin/view/Main/RqmApi) to GET work item resource and perform the calculation using the resolvedTime/creationTime (see https://jazz.net/projects/rational-quality-manager/api-doc-2.0/api-files/schemas/qm_xsd/elements/workitem_2.html). In RQM 3.0.1, work items are maintained in RTC.