How do I filter by the parent ID so that it shows Parent Prj Child Pr Lvl1, Child Pr Lvl1 Prj Pr Lvl2 Pr, and so on so forth. 

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • If the hierarchical relationship is defined as self join in Incorta, the flattened hierarchy can be generated behind the scene.  Several hierarchy related feature can be enabled.  One of the feature is to allow us to use the Is Descendant operator on the column from the hierarchy table.  

    If you are just talking about viewing these level columns in a single column from the table, The merged column can provide such view that Incorta will show the grouping attributes in a single column with tree like structure and you can collapse or expand the individual branch.

    The same view can be accomplish if the schema design include a self join enabled hierarchy table, we  can enable the view by enabling the column as a hierarchy and specify the number of levels will be displayed.

Like Follow
  • 2 mths agoLast active
  • 1Replies
  • 13Views
  • 2 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!