It's all about the answers!

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

×42,865

question asked: Aug 26 '09, 6:22 a.m.
question was seen: 3,564 times
last updated: Aug 26 '09, 6:22 a.m.

Related questions

Using resolution in Reports

0
Bharath M (546●54●28) | asked Aug 26 '09, 6:22 a.m.
Hi ,

I would like to use Resolution of workitems in a Report generation. But apart from LIVE_WI_CNT , I dont see a snapshot where I can find Resolution.

As in one of my report I need to use a combination of both State and Resolution of Workitem, is there a way to pull Resolution from any of the existing table?

Thanks,
Bharath

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | answered Aug 26 '09, 9:25 a.m.
JAZZ DEVELOPER
On 8/26/2009 6:23 AM, littleheartb4u wrote:
Hi ,

I would like to use Resolution of
workitems in a Report generation. But apart from LIVE_WI_CNT , I dont
see a snapshot where I can find Resolution.

As in one of my report I need to use a combination of both State and
Resolution of Workitem, is there a way to pull Resolution from any of
the existing table?

Thanks,
Bharath


Hi Bharath,

Currently, you're correct, the only access to the resolution field is
through the live work items table (which means you can't do historical
reports on resolution). If you open an enhancement request in the
Reports component we can take a look at this for a future release.

james
RTC Reports Team Lead
0
permanent link
Bharath M (546●54●28) | answered Aug 27 '09, 6:59 a.m.

If you open an enhancement request in the
Reports component we can take a look at this for a future release.

james
RTC Reports Team Lead

Thanks for the update James. I have opened an enhancement request @

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=92786

Thanks,
Bharath
0
permanent link
Daniel Cox (426●1●16●8) | answered Aug 27 '09, 8:22 a.m.
On 8/26/2009 6:23 AM, littleheartb4u wrote:
Currently, you're correct, the only access to the resolution field is
through the live work items table (which means you can't do historical
reports on resolution). If you open an enhancement request in the
Reports component we can take a look at this for a future release.


James - I was a bit surprised to learn that this wasn't in. For example our need is to show how many defects are being resolved as deferred/won't fix/fixed each day/week to track resolution trends. Is this something that you haven't heard form others?

With 2.0 we now have the capability to have custom attributes in the workitem snapshot for reporting purposes. I guess the built in attributes are the ugly stepchidren :).
0
permanent link
James Moody (3.3k●2●4) | answered Aug 27 '09, 11:51 a.m.
JAZZ DEVELOPER
On 8/27/2009 8:23 AM, xdcx11 wrote:
jmoodywrote:
On 8/26/2009 6:23 AM, littleheartb4u wrote:
Currently, you're correct, the only access to the resolution field
is
through the live work items table (which means you can't do
historical
reports on resolution). If you open an enhancement request in the
Reports component we can take a look at this for a future release.


James - I was a bit surprised to learn that this wasn't in. For
example our need is to show how many defects are being resolved as
deferred/won't fix/fixed each day/week to track resolution trends. Is
this something that you haven't heard form others?

With 2.0 we now have the capability to have custom attributes in the
workitem snapshot for reporting purposes. I guess the built in
attributes are the ugly stepchidren :).


Hi Daniel,

While we do have support for this in the live case, we didn't add it in
the data warehouse yet. This is actually the first request I can recall
for it, but it's definitely something we'll look at in the 3.0 timeframe.

james

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.