Harvest

Hi everyone,

I need all information about the processes of one package. Help me with a query for this information (create, promove, check in, check out, aprove, users and dates) .

Thank you

Susana Duymovich

You can run this SQL query in a BIRT report in workbench:

SELECT HARENVIRONMENT.ENVIRONMENTNAME,
  HARSTATE.STATENAME,
  HARSTATEPROCESS.PROCESSNAME,
 
HARSTATEPROCESS.PROCESSTYPE
FROM HARENVIRONMENT
 
INNER JOIN HARSTATE
ON HARENVIRONMENT.ENVOBJID = HARSTATE.ENVOBJID

INNER JOIN HARSTATEPROCESS
ON HARSTATE.STATEOBJID = HARSTATEPROCESS.STATEOBJID

This will provide a processes report on every project and state.

If you want the report to be specific to just a particular project and state

then you can add a WHERE clause to this script...

WHERE HARENVIRONMENT.ENVIRONMENTNAME = '<harvestProject>'

      AND HARSTATE.STATENAME = '<statename>'