Wed, 2023-05-31 03:00
I need to create a report in which there are three connected objects. For example, Org Unit is connected to Position is connected to Person. I am able to build the report so this is produced.
However, ALL Person objects that are connected to the position are returned. For example, if the Org Unit was Germany Division and the Position was Sales Rep, my report that I have created returns Germany Division and Sales Rep but when it goes to connect the Persons to the Sales Rep, it includes Persons who occupy the Sales Rep Position outside of the Germany Division Org Unit.
Is there a way to filter the results of two connected objects based on a third object?
Let me know I need to explain myself better.
Thanks!
Hi Stefan,
but this means, that somewhere in a model, there is another OrgUnit (say France Division) connected to the same Object definition of "Sales Rep". Otherwise no other results are possible, if you query this way:
1. for OrgUnit "German Division" give me all connected Positions
2. for every result of 1: give me all connected Persons
BR,
Torsten
Thanks for the post Torsten.
If you run the report in this way, would it not return all connected persons to that position, regardless of org unit? This is what I want to filter, if possible, so my output might look something like this:
1. Org Unit: Germany Division
2. Org Unit: France Division
The tricky thing here is that there is no direct connection between person and org unit. While this may be an easy fix for this example (just create a connection in the database between persons and org unit), I have other ideas for this type of filtering in which it would not be practical to connect the first and third element in the chain.
Thanks again for your help,
Stefan