Is it possible to list all projects and views that contain files in Native 1 format?

0 Likes

Problem:

Is it possible to list all projects and views that contain files in Native 1 format?

Resolution:


  • Product Name: StarTeam
  • Product Version: All
  • Product Component: Server
  • Platform/OS Version: N/A

Using the following SQL Query you can capture information on the views and projects a file belongs to based on the filename. In this example a list of view names and the projects they reside in will be returned for the file named "MyFile.txt":

SELECT Syn_File.Name, Syn_File.Archiveformat, Syn_View.Name as ViewName, Syn_Project.Name as ProjectName
FROM Syn_File, Syn_View, Syn_Project
WHERE Syn_File.Viewid = Syn_View.ID
AND Syn_View.Projectid = Syn_Project.ID
AND Syn_File.Archiveformat = "1";


Old KB# 29919
Comment List
Related
Recommended