Problem
The order of tree elements in the project browser should be queried in SQL.
Die Reihenfolge der Objekte im Projekt-Browser soll über SQL abgefragt werden
Approach – Ansatz
Usage of the TPos column within the tables t_object and t_package.
Verwendung der TPos Spalte in den Tabellen t_object und t_package.
Solution – Lösung
SELECT b.TPos as Package_Position, b.Name as Package_Name, a.TPos as Object_Tree_Position, a.Object_ID, a.Name as Object_Description FROM t_object a INNER JOIN t_package b ON a.Package_ID=b.Package_ID WHERE Stereotype='Process Step' ORDER BY 1,2,3