logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
sridharkannan  
#1 Posted : Wednesday, May 20, 2020 12:42:47 PM(UTC)
sridharkannan

Rank: Newbie

Groups: Registered
Joined: 5/20/2020(UTC)
Posts: 1
India
Location: Mumbai

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

Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.