1 Reply Latest reply on Apr 8, 2018 4:31 PM by Amen Allah Jlili

    Get parent file name from alternate configuration name in EPDM via SQL

    Guy Edkins

      I am doing some work with Excel and embedding the Conisio link to the file in the vault within a cell using the SQL call shown below. What I need to do is if I have just the SW configuration alternate part number defined in the SW file config table as $PRP@PART NUMBER  (not the actual configuration name) and get back to the parent file of the configuration to then create the Conisio link. The configuration name is mapped in the data cards via the Part Number custom property and reports out nicely through the data card as seen here.  Can someone point me to the table that stores this alternate name data and perhaps suggest how I can tie it back to the parent file.  I suspect it will be a Join to the Documents table.

       

       

      (SELECT Documents.Filename, CONCAT('conisio://NT VAULT/explore?projectid=',Projects.ProjectID,'&documentid=',Documents.DocumentID,'&objecttype=1') AS 'DocumentLink'

      FROM Documents INNER JOIN DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID INNER JOIN Projects

      ON DocumentsInProjects.ProjectID = Projects.ProjectID WHERE (Documents.Deleted = 0) And (Projects.Deleted = 0) And Documents.FileName = '<filename>'