We currently do not store the history of approval activity in the data warehouse. You are very welcome to submit an enhancement request that we can consider for 3.0.

On 11/5/2009 2:22 PM, Gontzzo wrote:

Client& Server: v2.0.1 (latest)

Situation:
I am developing a Birt log report for a client and it must go into
production soon.

Problem:
I am having trouble to find the DATE in which the work item (a Change
Request) was approved.
By approved, I mean within the Approvals tab, when its overall state
is 'approved' (see screenshot1 attached).

I looked all over the server data source tables, and it seems it is
not there. But, when I go to the History tab, I can see that the date
is actually being tracked and displayed (see screenshot2 attached).

Within the LIVE_SNAPSHOT table, I was able to find a bunch of stuff
regarding approvals and approvers, but the date is not there.

Any idea?
Is there any way to track the History tab information?

Thanks in advance!

Screenshot1:

http://img214.imageshack.us/img214/2193/screenshot1.th.gif

Screenshot2:

http://img693.imageshack.us/img693/9480/screenshot2.th.gif

As Rafik mentions, we don't store this in the data warehouse. However,
it's not stored in the repository either. The individual approvals are
there, and the cumulative state is there, but even if you could get at
the history of a work item from the live snapshot (which you can't),
you'd have to compute manually when the cumulative state becomes
approved, by looking at every approval inside it, and tracking when
enough of them became "Approved". But then you'd also have to know the
rules about how the cumulative state works (i.e. whether it's a majority
rules, or a single vote can veto the approval, or whatever)... I'm not
sure if this is configurable or not but if it is, you don't have access
to it.

james
RTC Reports Team Lead