Need a report that lists all projects for a particular department
Article ID: 113574
Updated On:
Products
CA Harvest Software Change Manager - OpenMake Meister
Issue/Introduction
My departments are identified by a code entered into the "Note" field for each project. I need to get a report that lists only the names of all projects for a particular department.
Environment
CA Harvest SCM all versions and platforms
Resolution
Here is an example statement that would produce the requested report:
SELECT ENVIRONMENTNAME
FROM HARENVIRONMENT
WHERE NOTE = 'Department A'
ORDER BY ENVIRONMENTNAME
SELECT ENVIRONMENTNAME
FROM HARENVIRONMENT
WHERE NOTE = 'Department A'
ORDER BY ENVIRONMENTNAME
Feedback
Yes
No
Powered by
