I think I see the error in my ways. The part type that has the attribute associated to it is a WTPart soft type, further, the attribute I was searching for is a classification attribute.
So, it works as expected with attributes associated to the soft type. Now I need to figure out how to join the attribute value to the soft type through the classification node?
Any ideas? Has anyone built a successfull query for classification nodes and attribute value?
Thanks,
Cam
The attached zip file should get you what you need. It is easiest to run two queries, one to get you the node info you need, then another to return the wtparts by an internal node attribute. This works best using a wildcard against classification hierarchy ID, which lets you go up the structure and get everything from under a given node. Note that in Windchill 10.2 the classification object model is different and these queries won’t work.
In Reply to Cameron Swaner:
I think I see the error in my ways. The part type that has the attribute associated to it is a WTPart soft type, further, the attribute I was searching for is a classification attribute.
So, it works as expected with attributes associated to the soft type. Now I need to figure out how to join the attribute value to the soft type through the classification node?
Any ideas? Has anyone built a successfull query for classification nodes and attribute value?
Thanks,
Cam
PLM Solution Architect
-----
Lewis
Thanks: This is another piece to the puzzle.
What I am trying to get it the Part information including attribute values from specific attributes in the classification node.
How can I get the attribute values from an string attribute that is part of a classification node?
I know I can get them with attribute definition, string value, etc. However, I need to make the proper outerjoin to allow for a null value in one of the classification attributes, otherwise my entire report is blank.