AnsweredAssumed Answered

Where Used/Contains Search Independent of Version

Question asked by Adam Meyer on Apr 30, 2009
Latest reply on Feb 28, 2012 by Lee CS Young
  • Comment • 18
Is there a way to do a where used or contains search that is independent of the file version? Right now, if I do a where used search on a part file, I have to go through each version to find what assembly uses that part. This gets even more complicated when you add configurations to the mix.

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?
1-A5CHD1
1-A5CHD1 May 5, 2009 7:24 PM
Correct Answer
Here is a quick and dirty report that will return the same info.

@[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}
]
See the reply in context
No one else had this question

Outcomes