It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,837

question asked: Apr 16 '10, 6:21 a.m.
question was seen: 6,144 times
last updated: Jul 12 '13, 6:58 a.m.

Related questions

Query to retrieve defects that have been reopened

2
francesca curzi (31●1●1) | asked Apr 16 '10, 6:21 a.m.
Hi! Is it possible to create a query to retrieve all the defects that have been reopened? I mean .. not just the ones that currently have the status in Reopened but also the ones that are now closed but were reopened. Thanks
Comments
Ned Bader commented Jul 11 '13, 9:56 p.m.

It seems like there is a legitimate need for this report  (defects that have been reopened at least once in their history) . Has this report been created or is it available for import.  If it is not generally available - what needs to be done to make it available?

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Geoffrey Clemm (30.1k●3●30●35) | answered Apr 16 '10, 8:47 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You cannot (to my knowledge) refer to previous states of a defect in a
query, but you can write a report to do so, based on the information
stored in the data warehouse (updated normally once a day).

Cheers,
Geoff

fcurzi wrote:
Hi! Is it possible to create a query to retrieve all the defects that
have been reopened? I mean .. not just the ones that currently have
the status in Reopened but also the ones that are now closed but were
reopened. Thanks
0
permanent link
francesca curzi (31●1●1) | answered Apr 20 '10, 10:40 a.m.
Thanks!

Could you please give me any advice on this?
Which are the parameters I can select to create this report?


You cannot (to my knowledge) refer to previous states of a defect in a
query, but you can write a report to do so, based on the information
stored in the data warehouse (updated normally once a day).

Cheers,
Geoff

fcurzi wrote:
Hi! Is it possible to create a query to retrieve all the defects that
have been reopened? I mean .. not just the ones that currently have
the status in Reopened but also the ones that are now closed but were
reopened. Thanks
0
permanent link
Jim Yu (11) | answered Aug 22 '12, 4:40 p.m.
@Geoff

We are also interested in a query for reopened defects.
Could you please elaborate on how to create such a report?
Comments
Ned Bader commented Jul 11 '13, 9:55 p.m.

It seems like there is a legitimate need for this report  (defects that have been reopened at least once in their history) . Has this report been created or is it available for import.  If it is not generally available - what needs to be done to make it available?

0
permanent link
sam detweiler (12.5k●6●195●201) | answered Jul 12 '13, 12:07 a.m.
we specifically created this state in our workflow to insure it was possible. and easily using the time in state report data.

I think without the specific state, that you will have some complex calculations to do.
Comments
Ned Bader commented Jul 12 '13, 1:23 a.m.

Thank you Sam for this information.   Do you know in which version of RTC was the "Time In State Report" added?   Can this report be imported into RTC 3.0.1 - if it is not readily available?

- Thank you

sam detweiler commented Jul 12 '13, 6:58 a.m.

this report is in RRDI or Rational Insight.  RRDI is free.
many of the reports require additional data that is not present in the RTC database.
this time in state report is one of those.  the time in state values are calculated as part of the RRDI ETL jobs that run on schedule (daily by default).

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.