Hi,

I have a report in which I select the user from an Enum List. The user table contains a "treeleft" and "treeright" column.
For example, consider the following records in user table
ID,Name,TreeLeft,TreeRight
1,Manager,1,6
2,Sales Person 1,2,3
3,Sales Person 2,4,5

At the time of report execution, when the "Manager" is selected in the prompt, the treeleft and treeright of this selected user should be considered and all leads assigned to all the users where treeleft >= 1 and treeright <= 6 should be displayed

So the output of the above should be all leads assigned to "Manager", "Sales Person 1" and "Sales Person 2".

The join between the Lead and User table is a foreign key in the Lead table where the column name is userid

Or atleast guide me to the topic where I can find a similar problem as stated here

Edited by user Thursday, May 21, 2020 7:59:52 AM(UTC)  | Reason: Not specified