Solr indexing - database query to get partnumbers classified against the classification node

[vivek2]

Version: Windchill 12.1

Use Case: Hi All, We are using Solr for indexing along with Windchill. We have defined classification nodes and their attributes. We want to database query to find the list of part numbers which are classified against perticular node. In classification search explore, result are varying due to acl's, so we are looking for db query to get the output.

Description:

ex - classification node name - Bolt.

In system may be 100 parts are classified against classification node "Bolt". In classification search explore, not getting all 100 object as result controlled by ACL's, so we are looking for DB query to get all classified records against the classification node.

[avillanueva]

Are you looking at doing this directly against the database or via a query builder report? You can setup a query builder report to override ACLs and give you a true answer. I have a basic report the returns the Part Classification attribute. Ensure you have the right constraints so that you get the right view, latest iteration and latest version if you want to filter out those as well. This will show you the node so not all nodes below.

Note also, the count that returns from the Classification Search is not always accurate. It relies on SOLR and there have been a number of posts that report discrepancies in this number,

[vnamboodheri]

Hello @vivek2,

It looks like you have a response from our community champion. If it helped you solve your question, please mark the reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Vivek N.
Community Moderation Team.