Skip to Main Content

Oracle Apex APEX 22.1 - Tree Structure

SANPATJul 25 2022

Dear Friends
I would like to create a Tree structure on form along with select tree details on the right. already created the Sql query for tree structure, but unable to design in forms.
Created a blank form . in that selected the following query . now in the attribute what i should select as per this query.
Please suggest.
image.png
SELECT
LEVEL as Seq_No, ECN_NO, ITEM_TYPE,
RPAD('/', (level-1)*1, '/') || CHILD_ITEM AS BOM_TREE,
TO_CHAR(PARENT_item) PARENT_item, TO_CHAR(CHILD_ITEM) CHILD_ITEM,
PRODUCED_QUANTITY, CONSUMED_QUANTITY, ROUND(CONSUMED_QUANTITY / PRODUCED_QUANTITY,7)RATIO, FIXED_LEAD_TIME
FROM view_FINAL_ecn
CONNECT BY PRIOR CHILD_ITEM=PARENT_ITEM
START WITH item_type ='A'
ORDER SIBLINGS BY (item_type)

Sanjay

This post has been answered by fac586 on Jul 25 2022
Jump to Answer
Comments
Post Details
Added on Jul 25 2022
1 comment
448 views