Cancel
Showing results for 
Search instead for 
Did you mean: 

Query Builder: How to find ItemRevision with no dranwning of model.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor

Hey,

I am wonder how to create a Query to find Item revisions(witch are holding NX parts datasets of assembly) with no generated drawning for NX model in this Item revision.

 

We just want to check if all parts of assembly has drawnings.

 

Any clues?

 

Best Regards

Michał Grygonis

4 REPLIES

Re: Query Builder: How to find ItemRevision with no dranwning of model.

Creator
Creator
We can write a Custom script to find out list of parts do not have datasets. There is no inbuild option available.

Re: Query Builder: How to find ItemRevision with no dranwning of model.

Solution Partner Valued Contributor Solution Partner Valued Contributor
Solution Partner Valued Contributor
Hey, Thank you for fast reply. By custom script you mean custom query?

Re: Query Builder: How to find ItemRevision with no dranwning of model.

Creator
Creator
No. Standalone JAVA script which will connect the Teamcenter offline or through TC Shell.

Re: Query Builder: How to find ItemRevision with no dranwning of model.

There might be a option.

Create a querry with the search class ITEMRevision.

Reference to a property of the drawing dataset and add it to the querry.

A property should be choosen which always has a value.

Set it to value: IS_NULL

 

I have not tested it maybe it is not working when the querry cannot find the referenced property.