Need help with Harvest package history reporting

Victor Peters's picture
Victor Peters asked on November 19, 2010 - 6:12am | Replies (1).

I've been trying to get some reporting working on package history and experience some 'challenges' to obtain the right set of data.

What I need is the (average) time it takes (or took) for a package to get from state X to state Y in a given environment.
I can get a per environment list of all Created, Promote and Demote actions from table harPkgHistory (plus the date/time of execution). But when a package has been promoted/demoted into a state more than once, the query returns too many rows.

Any help would be very welcome ...

1 Answer

Warren McCall's picture

It is returning multiple rows because you aren't filtering on the latest date. You will probably want to use a max(date) function to select the latest promote date to the State Y. This will then ignore any promotions that were performed before the max(date) in your resultset.



CMCrossroads is a TechWell community.

Through conferences, training, consulting, and online resources, TechWell helps you develop and deliver great software every day.