AnsweredAssumed Answered

SQL Query help - show linked document name

Question asked by Walter Bednarz on Aug 12, 2013
Latest reply on Aug 18, 2013 by Tim Webb

I would consider myself a SQL query hacker. Trying to come up with a query that shows a list of edrawing markup files (serialized file naming with MRK- as the prefix) in a vault and the original solidworks file I linked to it via a Paste as Reference. Here is what I have so far:

 

select Documents.Filename as 'Markup File', XRefs.XRefDocument as 'Original Document'

from Documents

join XRefs on Documents.DocumentID=XRefs.DocumentID

where Filename like 'MRK-%' and Deleted=0

 

My results show:

 

Markup FileOriginal Document
MRK-000792 - Increase radii to 30 mm.eprt4678

 

  I would like to see the file name instead of document id in the second column. Any thoughts on how to do that?

Outcomes