Hi all,
This question is related to https://community.dataminer.services/question/mn-tree-control-alarms-not-bubbling-propagating-up/?hilite=%27tree%27%2C%27control%27, however, I could not fix my problem using the answer provided there.
I am trying to create a tree control with 3 layers where a child may belong to multiple parents and that parent can have multiple children. The problem is illustrated in the figure below:
In this example, an employee can belong to multiple departments, while a department can have multiple employees. Besides that, these departments belong to a specific building. As you can see, the alarms do not propagate to the departments but do to the building. Also note that, if an employee only belongs to one department, the issue disappears.
To achieve this structure, a relations table is used to hold the IDs of the departments and employees as foreign keys. Then, the relations tag and tree control were defined as follows:
Table 700: Buildings; Table 100: Departments; Table 300: Relations and Table 200: Employees
What can be the cause of this issue?
Thank you!
Hi Diogo,
Have a look at the following article: Treecontrol M:N Relations
It seems that your missing some tables to link the Departments with the corresponding people, also a filter should be used on treecontrol parameter
If I implement the example from the link above, I get the following result:
If I change the protocol a bit to reflect your use-case it seems to work as expected: