We have just started using EPDM after converting from DBWorks.
Historically we have PDF's of hand or 2D generated drawings and also 3D models and drawings.
If a part/assembly is required in a higher level assembly but a pdf of the 2D exists we would model it but not approve it.
Viewers can't see non approved models or drawings.
It is the engineer's responsibility when they redraw something on SolidWorks to obsolete the old version pdf. Typically they have the part number as the file name.
This, in some cases, is not happening.
I need to be able to quickly identify if this has not happened
Is there an easy way to search for file names that have duplicates but have different extensions?
Thanks
Hi Russel,
As i mentioned remove the "HAVING (COUNT (Filename) > 1))" coz this line is sorting filename matcing fully.
If the query isint running try removing "GROUP BY Filename"as well.and alos add a")" at the end of 5th line.
--------------------------------------------------------
Select D.DocumentID, D.FileName AS [File Name], P.Path AS [Project Path]
From Documents AS D
INNER JOIN DocumentsInProjects AS DIP ON D.DocumentID = DIP.DocumentID
FULL OUTER JOIN Projects P ON DIP.ProjectID = P.ProjectID
WHERE D.Filename IN (Select Filename FROM Documents Where Deleted = 0)
--GROUP BY Filename
--HAVING (COUNT (Filename) > 1))
ORDER BY D.Filename
__________________________________________________
Sorry no SQL here ...
You may require even advance query if you want to sort all the files with same name but different extension.
The above query will match names starting from first char.
Regards
Ravi T