I hope someone could help me with my issue. have an SQL-Database with Elements. This table already include the nodes (add1 to add6) of every element. Now I want to create the Hierarchy but I dont get the order I Need (I think, the depth is missing).
(The Hierarchy should present a fix structure, meaning add1 as parent from add2 is at bottom, add2 as parent from add3 directly above add1 and so on))
One Thing is important. The fields from the SQL-Database must be used. It is not possible to exclude this into an excelfile due to redundancy issues (we unfortunately had that in the past)
Example of Solution (Structured View):
This is the part of the Script that I already have. It is creating the reporting lines but the order is not in there. Everything is mixed up.
Your code looked quite diiferent to the approach provided within the link and the sub-links from them. There will be an extra load-statement HIERARCHY used and you tried to get something similar with this one-level loop. I'm not sure but I think that these approach will be rather not work.
I haven't yet used HIERARCHY by myself (I have no use-case for this) but I would try to adapt the logic and would adjust my data appropriate. If this don't worked then would be a small example-app with a few inline-tables helpful.