Self Joins
SeedCodeHierarchy.SelfJoins History
Hide minor edits - Show changes to output
Changed lines 7-8 from:
You can even use a join table between them. As an example, here is a set of data table occurrences were the level 1 and level 2 items are from the same table, "Company":
to:
You can also use a join table between them. As an example, here is a set of data table occurrences were the level 1 and level 2 items are from the same table, "Company":
Changed lines 1-2 from:
!! Can the hierarchy show self joins within the same table
to:
!! Can the hierarchy have different levels be from the same table?
Changed lines 9-10 from:
%center% http://www.seedcode.com/rootimages/stikipad/hierarchy/selfjoins.png
to:
%center% http://www.seedcode.com/rootimages/stikipad/hierarchy/selfjoin.png
Added lines 1-10:
!! Can the hierarchy show self joins within the same table
Sure. The hierarchy can show self joins so that records form the same table populate different levels of the hierarchy. For instance, you may want something like "Companies" to be your top level, and then have "Related Companies" be your second level, where both "Companies" and "Related Companies" are records from the same "Company" table in your file.
Remember, the "data" table occurrences in the hierarchy are always named "HiearchyDataLevel1", "HiearchyDataLevel2", etc. but they can point to any tables you wish: they can even all point to the same table as long as you now how to relate level 1 to level 2, etc. in a way that makes sense.
You can even use a join table between them. As an example, here is a set of data table occurrences were the level 1 and level 2 items are from the same table, "Company":
%center% http://www.seedcode.com/rootimages/stikipad/hierarchy/selfjoins.png
Sure. The hierarchy can show self joins so that records form the same table populate different levels of the hierarchy. For instance, you may want something like "Companies" to be your top level, and then have "Related Companies" be your second level, where both "Companies" and "Related Companies" are records from the same "Company" table in your file.
Remember, the "data" table occurrences in the hierarchy are always named "HiearchyDataLevel1", "HiearchyDataLevel2", etc. but they can point to any tables you wish: they can even all point to the same table as long as you now how to relate level 1 to level 2, etc. in a way that makes sense.
You can even use a join table between them. As an example, here is a set of data table occurrences were the level 1 and level 2 items are from the same table, "Company":
%center% http://www.seedcode.com/rootimages/stikipad/hierarchy/selfjoins.png
