Issue with Query builder and CAD Documents status

[slapha]

Version: Windchill 12.0

Use Case: Trying to build a report to output all CAD objects, object specific parameters, and status.

Description:

Overall the report I have works, except for 1 field.

I had to use the CAD Document table due to the way the object parameters were set up.

The report works, but when I run it, status.status shows "Checked In" for items that are checked in, but also for items new in someone's workspace. While this might be useful information sometimes it's not the core of what we need from this report and would rather filter those out.

Assuming it's a CAD document Status versus the EPM Document status. I tried to link CAD Document to EPM Document but the connections have failed. I've done EPM Document reports with proper status data, but they wouldn't get me the object attributes in this system (and I can't change this system for other reasons).

Location does have /Default/... and /<user>/... but also not filterable. 

Any thoughts on how I can limit this report down to just common space items or connect to the other tables to gather that info? Thanks,

[joe_morton · Accepted solution]

I'm not sure if this is the best way, but what I typically do is link the CAD Document to Administrative Domain, then add a Criteria that Administrative Domain.Name equals default

I'd love to learn if others have found a more elegant solution to omit CAD objects in Workspaces.

[slapha]

This did help me narrow down the results. Though I too would love a more elegant solution if anyone has one.

Status.status showing "checked in" for new in workspace items seems like an error to me. Though wouldn't doubt if it's always been that way.

[d_graham]

@joe_morton 

I just wrote a query report for a company to get all  Cad Assemblies, Cad Drawings and Cad Components that are latest rev.iteration (just the absolute latest) in the specified Product or Library that have not been published.

When I saw this post I wrote a query to find all objects not in WS.

The query builder technique is the same if filter out objects that are not X, X being whatever.

@slapha ,

Can you upload your reports qml file to the case?

This would allow people to see the report and fix it for you.

[slapha]

I tried using https://www.ptc.com/en/support/article/CS236226 to connect CAD Document to EPM Document, but status is still showing as checked in.

[Marco_Tosin]

I'm not sure if I understand your request correctly, however I will point you to this article regarding objects that are new to the user workspace and not yet checked in.

How to get the new object list that are uploaded but not checked-in from Workspace

And also this

Query Builder report to fetch checked out objects in user's workspace

I hope it can help you.

[anursingh]

Hi @slapha,

I wanted to see if you got the help you needed.

If so, please mark the appropriate reply as the Accepted Solution. It will help other members who may have the same question.
Of course, if you have more to share on your issue, please pursue the conversation. 

Thanks,
Anurag