Skip to main content
23-Emerald IV
October 13, 2014
Question

Re-publish ideas needed

  • October 13, 2014
  • 16 replies
  • 5489 views
There doesn't appear to be an out-of-the-box way to force everything to republish.

Due to changes in our publish rules (additional files) and the creation of a publish filter (for extended positioning assemblies), I need to republish everything.

Unfortunately, manually republishing ignores the new publish filter. To make it work, all existing representations have to first be deleted, then the objects submitted again for publishing.

Does anyone have an easy way to delete and re-publish the latest iteration of each revision of all cad documents?

If not, what about deleting and re-publishing the latest version only?

Last resort, does anyone have an easy way to simply delete ALL representations system wide?

Thanks!

Tom U.

P.S. I realize you can develop custom publish schedules, but I don't have any idea how to work with/edit/create this custom Java code.

16 replies

22-Sapphire I
October 14, 2014
Creo View probably doesn't win any awards for the cases listed below, but once all is Creo-native (rather than coffee-stained photocopies), changes are very easy to check.

Seems that the Creo View Drawing Compare (historically ProductView Drawing Overlay) tool is one of the best things available in the system - probably underutilized because of both awareness and the fact that it requires publishing to be set up and always working.
TomU23-Emerald IVAuthor
23-Emerald IV
October 14, 2014
I think I figured it out. I just took out the section about product.

End result, all 'Released' + latest 'In Work' for both products and libraries. 🙂

select
derived.idA2A2
from
DerivedImage derived, EPMDocument epmdoc
where
epmdoc.idA2A2=derived.idA3theRepresentableReferenc and
epmdoc.statestate = 'RELEASED'

Union All

select
derived.idA2A2
from
DerivedImage derived, EPMDocument epmdoc
where
epmdoc.idA2A2=derived.idA3theRepresentableReferenc and
epmdoc.statestate = 'INWORK' and
epmdoc.latestiterationInfo = 1;


Total: 457,607

It's going to take the publisher a while....

Thanks!
18-Opal
September 2, 2015

Following all the great advice in this conversation I was able to get this to work for products, however I can't seem to get the syntax right to query in a library.  Any advice?

2-Explorer
September 2, 2015

windchill com.ptc.wvs.server.util.DeleteRepUtil -CONT_PATH "wt.inf.container.OrgContainer=HighTech" -containerOID "wt.inf.library.WTLibrary:31012" -repname "default"

Did you try the above? You can get the container id from the URL.

Thank you,

Binesh Kumar

Barry Wehmiller

18-Opal
September 2, 2015

Hi Binesh,

Yes I can do that,  but I was wanting to use the SQL query to find all the representations in a library.

-marc