Problem:

Is it possible to list all projects and views that a file belongs using SQL?

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_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.Name = "MyFile.txt";