I think there should be an option to update the assembly references when a part is revised without changing the version or revision of the assembly.
How are others dealing with this?
@[GetWhereUsed]
§Name [Get where used references.]
§Company [Gandinnovations]
§Description
[This query lists all referenced documents.]
§Version [1.1]
§Arguments
[
FileID TheFileID [S] [Select the file]
]
§Sql
[
SELECT DISTINCT
d.Filename,
pro.[Path]
FROM dbo.Documents d
JOIN dbo.XRefs xr ON d.DocumentID = xr.DocumentID
JOIN dbo.DocumentsInProjects dip ON xr.DocumentID = dip.DocumentID
AND dip.Deleted = 0
JOIN dbo.Projects pro ON dip.ProjectID = pro.ProjectID
WHERE d.Deleted = 0
AND XRefDocument = {TheFileID}
]
Thanks for the query.
Is there a way to run a query on a file by right clicking on it? Now you have the file in the search, but you have to start the report generator first and then add the file. I saw you can drag the file from the search/explorer to the report generator. It would be more user friendly to just right click on the file in the search and run the query. For some people all those extra programs and actions are hard to use...
Lee's solution is for "Where Used", anyone have a "Contains" accross all versions query they would be willing to share?
@[GetWhereUsed]
§Name [Get where used references.]
§Company [Gandinnovations]
§Description
[This query lists all referenced documents.]
§Version [1.1]
§Arguments
[
FileID TheFileID [S] [Select the file]
]
§Sql
[
SELECT DISTINCT
d.Filename,
pro.[Path]
FROM dbo.Documents d
JOIN dbo.XRefs xr ON d.DocumentID = xr.DocumentID
JOIN dbo.DocumentsInProjects dip ON xr.DocumentID = dip.DocumentID
AND dip.Deleted = 0
JOIN dbo.Projects pro ON dip.ProjectID = pro.ProjectID
WHERE d.Deleted = 0
AND XRefDocument = {TheFileID}
]