Find all EPM Documents without Visualisation

Forum|Forum|10 years ago
September 8, 2015
2 replies
7292 views

Hi Community,

im trying to figure out a way to find all EPMDocument without a created Visualisation. Which Database Fields hold the information about wheather a visualisation is created or not?

Regards

Stefan

Document Mgmt

Best answer by BineshKumar1

Hello Stefan,

If you are using report manager, you can link epmdocument and wtderivedimage using "Derived From The Derived Image" link and reference epmdocument to epmdocument master to get the name and number.

If you are looking at SQLs you can use the below to get all representations.

SELECT edm.documentnumber, edm.name, edm.cadname, ed.versionida2versioninfo "Rev", 
ed.iterationida2iterationinfo "Iteration", di.NAME
  FROM epmdocument ed, epmdocumentmaster edm, derivedimage di
  WHERE  ed.ida3masterreference =edm.ida2a2
  AND ed.ida2a2 IN di.ida3therepresentablereferenc;

Thank you,

Binesh Kumar

Barry Wehmiller

B

BineshKumar1

Answer

1-Visitor

Hello Stefan,

If you are using report manager, you can link epmdocument and wtderivedimage using "Derived From The Derived Image" link and reference epmdocument to epmdocument master to get the name and number.

If you are looking at SQLs you can use the below to get all representations.

SELECT edm.documentnumber, edm.name, edm.cadname, ed.versionida2versioninfo "Rev", 
ed.iterationida2iterationinfo "Iteration", di.NAME
  FROM epmdocument ed, epmdocumentmaster edm, derivedimage di
  WHERE  ed.ida3masterreference =edm.ida2a2
  AND ed.ida2a2 IN di.ida3therepresentablereferenc;

Thank you,

Binesh Kumar

Barry Wehmiller

T

TomU

23-Emerald IV

Binesh Kumar‌,

To get this to run on my system, I had to fix the case, add the database name to each of the tables, and add parenthesis to the 'IN' clause. This is on Microsoft SQL 2012 (with case sensitive collation.)

SELECT edm.documentNumber, edm.name, edm.CADName, ed.versionIdA2versionInfo "Rev",
ed.iterationIdA2iterationInfo "Iteration", di.name
FROM windchill.EPMDocument ed, windchill.EPMDocumentMaster edm, windchill.DerivedImage di
WHERE ed.idA3masterReference = edm.idA2A2 AND ed.idA2A2 IN (di.idA3theRepresentableReferenc);

Can you tell me what table(s) I need to link this to in order to see any related additional files and their names? I'm interested in determining not just if an object was published, but whether or not the proper additional files were published as well. Thanks!

B

BineshKumar1

1-Visitor

Hello Tom,

Sorry for the delayed response. Is this what you are looking for?

SELECT edm.documentnumber, edm.name, edm.cadname, ed.versionida2versioninfo "Rev",   
ed.iterationida2iterationinfo "Iteration", di.NAME ,ad.filename, ad.role 
  FROM epmdocument ed, epmdocumentmaster edm, derivedimage di,APPLICATIONDATA ad, HOLDERTOCONTENT htc   
  WHERE  ed.ida3masterreference =edm.ida2a2  
  AND ed.ida2a2 IN di.ida3therepresentablereferenc and htc.ida3b5 = ad.ida2a2 AND htc.ida3a5 = di.ida2a2 and ad.ROLE='ADDITIONAL_FILES';  
  /* Use ad.Role type PRODUCT_VIEW_* for Creo view, THUMBNAIL* from Thumbnails and ADDITIONAL_FILEs for Additional file types */

Thank you,

Binesh Kumar

Barry Wehmiller