AnsweredAssumed Answered

Hierarchical List

Question asked by navarro on Nov 30, 2018
Latest reply on Nov 30, 2018 by navarro

Hello,

 

I am trying to set up a hierarchical list view.

 

I have an Item table with the following relevant fields:

  • ItemID
  • ParentItemID
  • ItemName
  • ItemHierarchy
  • ParentIItemName

 

 

I have setp up two TOs to the Item table:

 

  • Item TO
  • ItemParent TO

 

 

I have set up the following self-join:

 

ItemPatent::ItemID  = Item::ParentItemID

 

 

 

My goal is to produced an ordered list of items as per their hierarchy and parent-child relationship.

 

 

 

Let us imagine  that I have entered the following 6 records:

 

 

Record 1

ItemID = 1

ParentItemID

ItemName = QM Manual

ItemHierarchy = 1

ParentIItemName

 

 

Record 2

ItemID = 2

ParentItemID = 1

ItemName = Cleaning

ItemHierarchy = 2

ParentIItemName = QM Manual

 

 

Record 3

ItemID = 3

ParentItemID = 1

ItemName = Change Control

ItemHierarchy = 2

ParentIItemName = QM Manual

 

 

Record 4

ItemID = 4

ParentItemID = 2

ItemName = Cleaning Form 1

ItemHierarchy = 4

ParentIItemName = Cleaning

 

 

Record 5

ItemID = 5

ParentItemID = 2

ItemName = Cleaning Form 2

ItemHierarchy = 4

ParentIItemName = Cleaning

 

 

Record 6

ItemID = 6

ParentItemID = 2

ItemName = Cleaning WI

ItemHierarchy = 3

ParentIItemName = Cleaning

 

 

 

When seting up a List View I gould like to get the following:

 

 

QM Manual (Hierarchy =1)

       Change Control (Hierarchy = 2)

       Cleaning (Hierarchy = 2)

           Cleaning Form 1 (Hierarchy = 4)

           Cleaning Form 2 (Hierarchy = 4)

      Cleaning WI (Hierarchy = 3)

 

 

 

I have tried Setting up a list view with two sub Submmaries:

 

  • Sub_summary by Item::ItemHierarchy
  • Sub_summary by Item::ParentItemName

 

 

 

When I sort the List by:

 

  • Item::ItemHierarchy
  • Item::ParentItemName
  • Item::ItemName

 

 

 

I am getting this:

 

 

1

           Parent Item:

                     Item: QM Manual

 

2

           Parent Item: QM Manual

                      Item: Change Control

                      Item: Cleaning

 

3

           Parent Item: Cleaning

                      Item: Cleaning WI

 

4

           Parent Item: Cleaning

                      Item: Cleaning Form 1

                      Item: Cleaning Form 2

 

 

 

Can this been achieved using a List view?

 

Is there an alternative easy way of achieving this other than on  pre FMP17 hierarchical portal based approaches?

 

Could this been achieved using FMP17 Master-Detail?

 

 

I apologize for asking so many questions.

 

Thanks

Outcomes