Relationship b/w user, role and user_has_role table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-23-2022 10:28 PM - edited 10-23-2022 10:55 PM
Hi Everyone, I am trying to understand how the relation b/w sys_user, sys_user_role and sys_user_has_role tables is configured. I have to implement the same related list setup but unable to do so.
On sys_user table, open a user profile, we can see a related list which consists of user contained roles but when we click on "Edit" on button related list, it will open slush buckets. Left side (Available list) slush bucket contains all roles and right side (Selected list) slush bucket contains already existing roles for the user. How come left side (Available list) is loading data from roles table even though Related List data is from sys_user_has_role table.
Please help to understand this functionality. @Ankur Bawiskar
#ITSM #OOB
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-26-2024 02:51 AM
Hi
Even i have the same requirements bro if you have Achieved that do let me know hopw you did that it would be helpful for me im stuk between how to achieve that