Finding which files are in the baseline

Products

• CA Harvest Software Change Manager - OpenMake Meister
• CA Harvest Software Change Manager

Issue/Introduction

When looking at the data view for my project in Harvest, it is hard to tell which files are part of the project's baseline and which were added later.  The Find Version tool can list all the files in the data view and the "Package" column can provide a clue about this:

However, using the Find Version tool to search for the contents of the package named "BASE" doesn't work.

Is there a way to get a listing of the files included in the baseline of my project?

Environment

CA Harvest SCM all versions and platforms

Resolution

Here is a query that will generate a list of all items associated with the baseline of a specific project:

SELECT HARENVIRONMENT.ENVIRONMENTNAME,
  'BASE' as PACKAGENAME,
  HARPATHFULLNAME.PATHFULLNAME,
  HARITEMNAME.ITEMNAME,
  HARVERSIONS.MAPPEDVERSION
FROM HARENVIRONMENT
INNER JOIN HARVERSIONINVIEW ON HARENVIRONMENT.BASELINEVIEWID = HARVERSIONINVIEW.VIEWOBJID
INNER JOIN HARVERSIONS ON HARVERSIONS.VERSIONOBJID = HARVERSIONINVIEW.VERSIONOBJID
INNER JOIN HARPATHFULLNAME ON HARVERSIONS.PATHVERSIONID = HARPATHFULLNAME.VERSIONOBJID
INNER JOIN HARITEMNAME ON HARITEMNAME.NAMEOBJID = HARVERSIONS.ITEMNAMEID
WHERE HARENVIRONMENT.ENVIRONMENTNAME = 'SampleProject' /* <--- Project Name goes here */
ORDER BY PATHFULLNAME, ITEMNAME

Additional Information

The above query works with both Oracle and SQL Server

More information about the project "Baseline" is found here: Administrate Projects and Lifecycles - Configure the baseline