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.
CA Harvest SCM all versions and platforms
Here is an example statement that would produce the requested report:
WHERE NOTE = 'Department A'
ORDER BY ENVIRONMENTNAME