2D and 3D drawings without a publications

Se scrivi in italiano difficilmente troverai qualcuno che ti risponde.

Dovresti anche specificare meglio il motivo della richiesta, per avere una risposta pertinente, altrimenti diventa difficile.

Grazie

If you write in Italian you are unlikely to find someone to answer you.

You should also better specify the reason for the request to get a relevant answer, otherwise it becomes difficult.

Thank you

It might be possible to do it with the Query Builder but I ended up writing an sql query

USE windchill_inst;

SELECT 
 A0.idA2A2,
 A0B.documentNumber,
 A0B.authoringApplication,
 A0B.docType,
 CONVERT(varchar, A0.modifyStampA2, 120) AS modifyStamp,
 A0.statestate,
 A1.classnameA2A2,
 A1.idA2A2,
 A2.namecontainerInfo
FROM 
 [windchill_inst].DerivedImage A3
 RIGHT OUTER JOIN [windchill_inst].EPMDocument A0 
 ON A3.idA3A6 = A0.idA2A2
 RIGHT OUTER JOIN [windchill_inst].EPMDocumentMaster A0B 
 ON A0.idA3masterReference = A0B.idA2A2
 LEFT OUTER JOIN [windchill_inst].DerivedImage A1 
 ON A3.idA2A2 = A1.idA2A2,
 (SELECT 
 A2.idA2A2, 
 A2.namecontainerInfo 
 FROM 
 [windchill_inst].ExchangeContainer A2 
 UNION ALL 
 SELECT 
 A2.idA2A2, 
 A2.namecontainerInfo 
 FROM 
 [windchill_inst].OrgContainer A2 
 UNION ALL 
 SELECT 
 A2.idA2A2, 
 A2.namecontainerInfo 
 FROM 
 [windchill_inst].WTLibrary A2 
 UNION ALL 
 SELECT 
 A2.idA2A2, 
 A2.namecontainerInfo 
 FROM 
 [windchill_inst].PDMLinkProduct A2 
 UNION ALL 
 SELECT 
 A2.idA2A2, 
 A2.namecontainerInfo 
 FROM 
 [windchill_inst].Project2 A2
 ) A2
WHERE 
 A0.latestiterationInfo = 1
 AND A0.branchIditerationInfo = 
 (SELECT 
 MAX(AA0.branchIditerationInfo) 
 FROM 
 [windchill_inst].EPMDocument AA0 
 INNER JOIN [windchill_inst].EPMDocumentMaster AA0B 
 ON AA0.idA3masterReference = AA0B.idA2A2
 WHERE 
 AA0B.idA2A2 = A0B.idA2A2)
 AND UPPER(A1.name) IS NULL
 AND A0B.docType <> 'NOTE'
 AND A0.idA3containerReference = A2.idA2A2;

A couple of query builder similar to your request

Query builder report to list all EPM Documents without representations in Windchill PDMLink

Find all EPM Documents without Visualisation

@AR_01 ,

I wrote an SQL query that finds CAD Docs that do not have pdf, dxf or step files created by publishing, however, it's difficult to say if this is really what you need.

Is the idea here to find CAD Docs that meet a criteria and then publish them? If yes, you really want a Java utility to find them and publish them rather than a Query Report or an SQL query.

Also, your title states "2D and 3D drawings without a publications" yet the body of your post states "all those cad documents".  Which is it? Drawings only or all cad docs?

Also, which iteration are you concerned about?

• Are you looking at all iterations?
• The latest iteration of each revision?
• The latest iteration of the latest revision?

Also, you state in your post, ""it possible to generate a report that identifies, starting from a code,"

What does "starting from a code" mean?

What code are you referring to?

Finally, once you have your list of CAD objects, then what?  My guess is you want to publish them.  True?

David