Identifying Markups

[TomU]

Does anyone know a way to easily identify which CAD objects have markups associated with them?  Sure, we can go one by one through each object's details page and look at the content tab, but it would be really helpful to know whether or not something has markups from a folder view or a table (like the list of promotion objects.)  Any suggestions?

[Marco_Tosin]

Hi Tom,

have already you looked at this discussion?

[mmeadows-3]

I wasn't able to import the 9.1 query into 11.x, even after updating the embedded URLs 'https://yourpdmlinkdomain.com'.  The QML is human readable and can still be used to reverse-engineer the query for 11.x.

There are also some relevant knowledge base articles that may help in building 11.x reports or SQL queries.  Not sure if the request is exclusively for WTMarkUp associations to CAD Documents or also WTParts to Annotation Sets.

• CS210700 - WTMarkUp to CAD Document relationships
• CS156270 - Annotation Set/WTMarkUp of CAD Document/WTPart related to a Change Notice/Task

[Marco_Tosin]

I have just imported the qml in my test system (11.1 M020)

See attached

[mmeadows-3]

I get the same error in 11.0 M030-CPS16, 11.1 M020-CPS08 and 11.2 M010-CPS01 when I select "Upload Report Template from QML".

"NOTIFICATION"

"The file you are attempting to import is invalid.  Only reports exported from Windchill can be imported."

Can you export the QML you were able to import and share the updated QML?

[Marco_Tosin]

You have to extract the QML files from zip.
Then upload it using the icon in attached image
[cid:image001.png@01D608FD.4BF0D1F0]

[mmeadows-3]

I build reports and import/export QML regularly.  It is just this one that doesn't want to import.

I extracted the QML and updated the URLs to match my test environment before import.  No other changes were made.  I even tried importing the QML without any changes.  In either case, I get the error.

The 9.1 QML syntax is significantly different from 11.x.  That is why I asked if you could export what you were able to import.  A QML exported from 11.x is more likely to import into 11.x.

Thanks

[Marco_Tosin]

I have imported exactly the QML file extracted from the zip attached in the discussion linked.

Have you used the second icon from the right to import the QML?

I think this should solve your problem.

It happens the same some months ago to another user.

[mmeadows-3]

Marco,

The 'upload' icon is what I have been using.

I also considered this to be a 'legacy mode' import but couldn't find a setting that would enable legacy QML import.

Any other ideas?

Thanks,

Matt

[Marco_Tosin]

No, I have no idea.

Anyway, you can recreate the report using attached image (you can choose the right type opening the qml files with any text editor). 

[Florent]

Hello Tom,

you can create an alias attribute that shows the markup name, and add this column to the promotion Object table.

If you're using WTPart, then the formula wouldn't be a bit more tricky.

[TomU]

I've never created an alias attribute before, so I'm trying to understand what this string should look like...

I guess for starters, why isn't 'WTMarkUp' listed anywhere in the Type and Attribute Management utility?  (or is it there but hidden?)

[TomU]

Okay, I've figured the database relationships out.  Now I just have to figure out how to translate these to the alias syntax.

SELECT
	edm.CADName,
	ed.versionIdA2versionInfo [Version],
	ed.iterationIdA2iterationInfo [Iteration],
	ed.statestate [State],
	edm.authoringApplication [Application],
	edm.docType [Document Type],
	--di.idA2A2 [Derived Image ID],
	--muv.idA2A2 [MarkUpTheViewable ID],
	--mu.idA2A2 [MarkUp ID],
	--mu.MarkUpType [MarkUp Type],
	--mu.additionalInfo [Additional Info],
	mu.name AS [Markup Name]
FROM
	EPMDocumentMaster AS [edm]
	JOIN EPMDocument AS [ed]
		ON ed.idA3masterReference = edm.idA2A2
	
	JOIN DerivedImage AS [di]
		ON di.idA3A6 = ed.idA2A2

	JOIN TheMarkUpTheViewable AS [muv]
		ON muv.idA3B5 = di.idA2A2

	JOIN WTMarkUp AS [mu]
		ON mu.idA2A2 = muv.idA3A5

It would be nice if the pencil icon could show up in this new 'Markup' column instead of just the markup name.  Even better, have clicking on the pencil icon directly open Creo View with the associated markup already active.  😀