Query based on attribute/status change
![]()
Can we do the following with RTC?
1. Create a query based on the change on a particular attribute. To be more specific, we want to generate a list of defects that have severity lowered, and then generate a report on the # of defects that have serverity lowered in each month. 2. Create a report based on status change? e.g. # of defects reopened (group by month), # of stories implemented in last 3 days (group by filed against). RTC does have very nice history record for each work item, however, when I try to create a query, it looks like I cannot create query based on "history". If we cannot create the queries that I mentioned through Eclipse client or Web Interface, can we do such search using command line, or even SQL? Thanks. |
3 answers
![]()
Geoffrey Clemm (30.1k●3●30●35)
| answered Jul 14 '10, 11:15 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You cannot query based on history (you can only query on the current
state), but you can do reports based on history (but note that the history in the warehouse is normally captured once-a-day, so would not have intermediate states that were created after one nightly capture but were modified before the next nightly capture. Cheers, Geoff On 7/14/2010 5:36 PM, atyyeung wrote: Can we do the following with RTC? |
![]()
Hi Geoff,
Could you please elaborate more on how to create the reports on history? Regards, Sunita You cannot query based on history (you can only query on the current Can we do the following with RTC? |
![]()
Geoffrey Clemm (30.1k●3●30●35)
| answered Aug 17 '10, 7:38 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
I'd suggest first looking at the main reports wiki page:
https://jazz.net/wiki/bin/view/Main/ReportsMain In particular, it is the "data warehouse" that holds history, so you'd want to look at the "Data Warehouse and Jazz Data Source Documentation" section. Cheers, Geoff On 8/17/2010 4:38 AM, sdinakar wrote: Hi Geoff, |
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.