Skip to main content
P
pmanwal1-Visitor
1-Visitor
February 3, 2017
Question

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

  • February 3, 2017
  • 1 reply
  • 2614 views

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

1 reply

B
BineshKumar11-Visitor
1-Visitor
February 3, 2017

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
    22-Sapphire II
    HelesicPetr22-Sapphire II
    22-Sapphire II
    September 7, 2020

    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

    Terms & ConditionsCookie settingsAccessibility statement