search cancel

Need a report that lists all projects for a particular department

book

Article ID: 113574

calendar_today

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