Organise Data to Tree Structure

1. Tree - "standard iDempiere way"

https://wiki.idempiere.org/en/Tree_(Window_ID-163)

Tree can be maintained in window/tab by drag and drop or in special form Tree Maintenance

Tree's can be organised automagically into tree - when admin mark it as (NF2.1 Tree Driven by Search Key) e.g 01 parent child (01A, 01B)

Purpose> idempiere zk components allow display data in tree and user can modify tree structure.

A. TYPE/AREA trees

these trees are predefined in iDempiere

• Menu - Primary Menu - AD_Menu (isSummary)
  • usage 1. https://wiki.idempiere.org/en/Reference
  • usage 2. https://wiki.idempiere.org/en/Reference-System
• Element Value - (Primary Account Element Value) - C_Element (has AD_Tree) +C_ElementValue (isSummary)
  • this can be imported.
  • note: C_Element has AD_Tree which allow select tree filter (this looks me same as Parent_Column_ID for custom table)
• Bpartner - (Primary Business Partner) - IsSummary, BPartner_Parent_ID
• Organization - (Primary Organization) - IsSummary
• Product - (Primary Product) - IsSummary
• Project - (Primary Project) - IsSummary
• Sales Region - (Primary Sales Region) - IsSummary

B. Tree for custom table

Allow define per tenant a tree for any window/tab

https://wiki.idempiere.org/en/NF3.0_Tree_On_Any_Table link

custom tables displayed by dynamic validation:

• ad_menu
• ad_org
• ad_pinstance
• ad_tree_favorite
• c_activity
• c_bpartner
• c_campaign
• c_elemenvalue
• c_project
• s_salesregion
• c_tax
• i_elementvalue - exclude ?
• i_reportline - exclude ?
• m_product_category
• m_product
• pa_goal

2. Table records parent/child relation defined by fields: parent_id and isSummary

iDempiere has defined on some tables %parent% and isSummary columns. This allow define hierarchical without iDempiere standard tree component.

ANALYSIS - ELEMENTS Parent column on tables

• A_Parent_Asset_ID,
• PA_GoalParent_ID
• ParentValue_Parent Key - used for import element value
• Parent_Org_ID
• Parent_Tax_ID
• BPartner_Parent_ID
• SalesRep_BP_BPartner_Parent_ID
• M_Product_Category_Parent_ID

SQL snippets

1--- get trees
2
3SELECT * FROM ad_tree WHERE TreeType = 'TL'