-
Where Used/Contains Search Independent of Version
I haven't used PDMWorks in a while, but in the search box- isn't there a check box that says "latest version" or something like that? If you uncheck that, it should search older file versions.-
Where Used/Contains Search Independent of Version
I was talking about the where used tab in windows explorer. I couldn't find a way to do a where used search using a search card.
I've attached a screen shot that might explain the issue better.-
-
Where Used/Contains Search Independent of Version
2009 SP2Jason Capriotti wrote:
What version of Enterprise are you on Adam?
-
-
-
-
Where Used/Contains Search Independent of Version
Adam,
You are right and I'm looking for the same solution,
I've understood that there is a way to generate report with the relvant information.
-
Where Used/Contains Search Independent of Version
Here's a workaround:
Delete the file and EPDM will present you with a confirmation, which will tell you where that file is referenced. Just hit cancel instead of delete.
-
-
Where Used/Contains Search Independent of Version
This is a problem at our company as well.
Can you make a service request for this so it can be implemented in a later service pack.
-
-
-
-
-
Where Used/Contains Search Independent of Version
The user has to have permission to delete the file for the references to show.-
Where Used/Contains Search Independent of Version
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}
]-
Where Used/Contains Search Independent of Version
Good job, Lee. Thanks for sharing.
Please send me an e-mail when you get the chance, please.
devon@pdmsolution.com
Thanks.
-
-
-
Where Used/Contains Search Independent of Version
Thanks Lee. That will work better since we don't allow files to be deleted that have been approved.
-
Re: Where Used/Contains Search Independent of Version
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...
-
Re: Where Used/Contains Search Independent of Version
You would have to use the API to do it in 2009 and before. In Enterprise 2010 when you do a where used, there is an "All Versions" in the Version dropdown list.-
Re: Where Used/Contains Search Independent of Version
Is it possible to default this tab to <All Versions> instead of the latest version?
-
-
-
-
Re: Where Used/Contains Search Independent of Version
Lee's solution is for "Where Used", anyone have a "Contains" accross all versions query they would be willing to share?
-
Re: Where Used/Contains Search Independent of Version
Jeff,
That would be a difficult query if you're looking for every parent and child item/file. Recursivley looking for every child item through every version? Ouch.
Parents only wouldn't be so bad and I could probably help you.
-
