AnsweredAssumed Answered

Adjust Relationship data by procedure

Question asked by awaker on Aug 14, 2018
Latest reply on Aug 15, 2018 by awaker



I have the following case:


I have an Employee/HR dashboard containing the entities subsidiary (A & B) and sales office (1 & 2).

After loading data from the server I have the following picture:


Employees of subsidiary A & B are all assigned to Sales Office 1. The problem is that this is not 100% correct, which relates back to our backend database. I know it should be fixed there, but this is not easy, that's why I am looking for a way to adjust entitiy assignment via procedure.


What I would like to do is to use the following criteria:

- If employees are in subsidiary B the entity should be sales office 2. If employees are in subsidiary 1 they should be assigned to sales office 1.


Hope my example is clear. General questions is if it is possible to adjust entities automatically by a procedure using predefined selectors. If so how can I do that?