Welcome to the Jazz Community Forum
Report for change of state of a workitem

Hi
We would like to have a report where in it lists all the workitems whose state has changed to verified by a particular user within a period.
I tried to use the Workitem_Chngs table, but it doesn't give me an option to check which user has made the change.
Am I missing something?
-- Bharath
We would like to have a report where in it lists all the workitems whose state has changed to verified by a particular user within a period.
I tried to use the Workitem_Chngs table, but it doesn't give me an option to check which user has made the change.
Am I missing something?
-- Bharath
5 answers

On 6/11/2010 7:23 AM, littleheartb4u wrote:
You're correct, the work item changes table does not include the user
who made the modification. I don't think there's a workaround for this
today.
james
RTC Reports Team Lead
Hi
We would like to have a report where in it lists all the workitems
whose state has changed to verified by a particular user within a
period.
I tried to use the Workitem_Chngs table, but it doesn't give me an
option to check which user has made the change.
Am I missing something?
-- Bharath
You're correct, the work item changes table does not include the user
who made the modification. I don't think there's a workaround for this
today.
james
RTC Reports Team Lead

On 6/11/2010 7:23 AM, littleheartb4u wrote:
Hi
We would like to have a report where in it lists all the workitems
whose state has changed to verified by a particular user within a
period.
I tried to use the Workitem_Chngs table, but it doesn't give me an
option to check which user has made the change.
Am I missing something?
-- Bharath
You're correct, the work item changes table does not include the user
who made the modification. I don't think there's a workaround for this
today.
james
RTC Reports Team Lead
Hmm.. But this could be an important feature for individual user reports right? Moreover, If I'm not wrong, currently we can't query on the history of workitem. The only way to do this is through reports. So this could be a good addition.

On 6/25/2010 2:07 PM, littleheartb4u wrote:
Hmm.. But this could be an important feature for individual user
reports right? Moreover, If I'm not wrong, currently we can't query
on the history of workitem. The only way to do this is through
reports. So this could be a good addition.
Yes, absolutely.
jmoodywrote:
On 6/11/2010 7:23 AM, littleheartb4u wrote:
Hi
We would like to have a report where in it lists all the workitems
whose state has changed to verified by a particular user within a
period.
I tried to use the Workitem_Chngs table, but it doesn't give me an
option to check which user has made the change.
Am I missing something?
-- Bharath
You're correct, the work item changes table does not include the user
who made the modification. I don't think there's a workaround for this
today.
james
RTC Reports Team Lead
Hmm.. But this could be an important feature for individual user
reports right? Moreover, If I'm not wrong, currently we can't query
on the history of workitem. The only way to do this is through
reports. So this could be a good addition.
Yes, absolutely.