4 Replies Latest reply on Aug 18, 2013 8:57 PM by Tim Webb

    SQL Query help - show linked document name

    Walter Bednarz

      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?