Hello, I'm trying to create a database view, i have no prior experience with database view.
Right now, process is to submit a form and request access to a "Group" and once the wf is completed, all "roles" within the group get added to user profile.
I am trying to create a database view that will show this requested item with the "Group" but also another column showing the "Roles" within that group. Currently, i have the "Group" showing but I can't find a way to get the "Roles" associated to the group on the database view.
Any help or feedback is appreciated, thank you!
