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.

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.

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.