How to get BOM structure up to end level using query builder (.qml).

[pmanwal]

We want to retrieve a multilevel BOM structure report using query builder. Please help in creating a qml to get multilevel BOM strructure

[BineshKumar1]

Multilevel BOM needs recursive database queries which is not currently possible in query builder. You have to use info engine/java api's for that. From query builder what you can get a single level though - http://www.ptc.com/appserver/cs/view/solution.jsp?n=CS72503

[HelesicPetr]

Hello,

I would add, if you use java api, then you can not use database functions on the result from java in the queryBuilder. 

I know and understand why but in my opinion it should be mentioned whit this suggestion.

PetrH