Nth level BOM explosion query based on condition

Hi All,

Please help me in sql query of BOM explosion based on condition.

There is a page two list value for Items : lov are value 1,value2.

Input : item number , value 1

Output: exploded BOM with condition.

Condition: while traversing the BOM, we need to validate the component/subassembly p2 list value. If list value is value1 ,ignore that component/subassembly (Do not traverse it).

This check should be at every level of traversal.


No Files Were Attached
raju1 Agile User Asked on November 26, 2018 in Software Development Kit (API).
Add Comment
1 Answer(s)

Hi Raju,

I see a similar question asked by you on BOM Nth level data which few of the folks responded in the below thread

Can you let us know the exact issue you are facing while using the existing query with the new conditions you shared. Your requirement seems specific to particular list values of items across level. So along with items you can join the P2 value and define your where-used condition. Should be simple to achieve. Let us know if you try and get stuck.


Arif Agile Angel Answered on November 26, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.