Markup and Annotation Report in Windchill - Need help Building URL to open the file in Creo View

[dwilliams]

Hello Gurus,

I've written a report that returns all the markups and annotations against a particular CAD document and/or particular user. The problem is that when the object that the markup was created against is no longer the latest, the UI does not allow the user to view or open the markup. Bug? PTC Case logged!

  Anyhow, i am trying to recreate the URL in the report that launches the markup in Creo View. I have been able to get all of the necessary data except for the application data id for the markup. Can anyone help me figure out the right way to get the application id linked and pulled into the report?

For the joins i have the following:

wt.viewmarkup.WTMarkUp - Role AObject Ref - wt.viewmarkup.WTMarkUp

wt.viewmarkup.TheMarkUpViewable - Role BObject Ref - wt.viewmarkup.Derived Image

wt.viewmarkup.Derived Image - Derived From Reference - wt.epm.EPMDOCUMENT

wt.org.WTUser - Ownership.Owner - wt.viewmarkup.WTMarkUp

I am building the URL as a concatenation as shown in the image below. I need to pull in the application id somehow and place it in the APPLICATION DATA ID placeholder.

Any help you can provide will be greatly appreciated.

Best Regards,

Dax Williams

[BillRyan]

I don't have a solution to the URL problem...but have you thought about enabling copy forward so the markup is attached to the latest?  I am able to open the annotation set from an older iteration when active in the information page (customized to show version history and reps)...maybe you can get the URL from this page to help reverse engineer what you are doing.

[ChrisSpartz]

I'm not too familiar with query builder. But on the DB level, WTMarkup and ApplicationData are linked through the HolderToContent table. HolderToContent's idA3A5 field points to the entry in WTMarkup and HolderToContent's idA3B5 field points to the entry in ApplicationData.

[dwilliams · Accepted solution]

Bill and Chris,

Thank you for your replies. I tried the Application Data linked to the WTMarkup through the content to holder link and everything linked fine. However, the URL wouldn't resolve using the application persist info id.

I was able to get the report working without linking the Application Data table. I used the persist info id from EPMDocument table. With this id, I am now able to open the annotation in Creo View directly from the report.

I realize this is just a workaround and we should be able to get to these annotations without this reverse engineered url. I am working with PTC to figure out why they are disappearing from the UI. However, this report is nice to easily find the annotations by a user or object and have a quick link to pull it up in Creo View.

I don't see anyway to attach the updated report to my reply, so if anyone is interested in this report please let me know and I can send it via email.

Thank you for your expertise,

Dax

[BineshKumar1]

That's great Dax and thanks for this report. This is very useful.

Could you update the Resource for reporting with this one?

[Marco_Tosin]

Dax,

I know you are a member of Reporting

I'm working to share information on reporting (query builder) here in the community because, as you know, for many of us this is a black box.

Some weeks ago Bjoern Saupp‌ told me that he is writing some articles to help people about reporting with query builder and also he's working to indexing this document Resource for reporting

In this way when someone will do a search in TS all QML will be visible, so I'm asking you, as Binesh, to please share your report.

Thanks

[dwilliams]

Hi Marco Tosin and Binesh Kumar,

  I have added the file to the Reporting group and I've also updated the Resource for reporting thread with a link to the file.

As a side note, I have about 150 query builder reports that I have written over the years that I should probably share up to these locations. I just have to find the time and best method to do so. Most of you are on Windchill 10 and without having a method to test on this build, i'm not sure any of these would be useful anyhow. Unfortunatly, I'm still stuck on Windchill 9.1.

Thanks for putting together these two resource locations for reports. Very useful.

Have a great day,

Dax Williams

[Marco_Tosin]

Hi Dax,

some of your reports are already in the document, coming from PTC User site (I cited you in the link).

They are accessible only for registered users of PTC users site.

If you find some time maybe you can start from this report, creating a new discussion, attaching QML file and editing the document with new link.

Thanks

[BillRyan]

Dax,

Your QML files are nice gold nuggets!  We are in WC 10.1 and evaluated your QML for finding Markups created in 9.1.  It worked with a slight change to find/replace the text with our server address.  Very beneficial.  If you have anything related to Family Tables...I will be very interested!      Thanks.

[dwilliams]

I have made some changes since originally getting this solved. The link below is to the latest version of the report I have:

https://www.ptcusercommunity.com/servlet/JiveServlet/download/8686-2-112284/EPMDOCUMENT_Markup%20and%20Annotation%20Report.qml.zip

Best Regards,

Dax

[STEVEG]

Thank you for this Dax.

I have one question.  I deleted some published view but noticed after running it again they were still listed in the report.  Any idea why?  I am on 10.1 and it runs fine.  Could that be the reason?

[dwilliams]

Hi Steve,

When I delete the annotations in Windchill 9.1, they are removed from the report. I tried deleting from both the Windchill and Creo View UI's and in both cases, it removed it from the report. I would assume the behavior to be the same in Windchill 10.1 but I have no way to test.

How are you deleting the annotations? This may give us some indication as to why we are seeing a difference.

Best Regards,

Dax

[STEVEG]

I am on the detail page and go to the Representations/Annotations table.  Right-click and delete.