Hello All,
I have a requirement to create a report which has list of users who has the role "A" or role "B" or role "C" in this month of time of role assignment.
For this I created a report on sys_user_has_role with conditions All>role is "A" or role is "B" > created this month
In this approach I was getting a user "Demo" who has both the roles "A" and "B" 2 times, as there will be 2 records for user "Demo" in sys_user_has_role table. But my requirement is to get these type of users captured only one time in the report. Let me know if there is any approach to take a particular user only time even if he/she has both the roles.
Thank You!
