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.
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
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:
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?
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.
Hi Geoff,
Could you please elaborate more on how to create the reports on history?
Regards,
Sunita
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
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?
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.
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:
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,
Could you please elaborate more on how to create the reports on
history?
Regards,
Sunita
gmclemmwrote:
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?
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.