Situation:
Using PHPRunner for visualization of business process information, most of Master-Detail relationships are recursive. Processes have sub-Processes, which itself are processes, tasks have sub-tasks, which itself are tasks, users have substitution-users, which itself are users, findings have sub-findings, States have Sub-States … the list is sheer endless.
Current Workaround:
At the moment I use a workaround, which is to copy a Sub-Process view from the Process-Table, which has two master-detail relationships, one in each direction, with the Process-Table, a Sub-Task copy with bi-directional relationships with the Task-table and so on.
Problems of current Workaround:
- It is a huge maintenance effort, maintaining two tables and keeping them identically
- It is also a lot of programming effort. It is necessary to modify titles, header, breadcrumb etc. dynamically in order to name them identically, regardless if the user drills down to a sub-item or accesses it directly.
- Also access control must be identical to both tables. Unfortunately customer admin (using dynamic access control) is not aware of this issue. So this needs programming effort too.
Request:
It should be possible to drag a master-detail relationship from a table to itself.