Database View

[rcoleTCS555]

I'm trying to create a Database View that combines the User, Role, and Group tables. I want to be able to generate a report that provides every role and group that is assigned to a user. I'm running into issue's with the Where clause. Here is my current configuration.

 Thanks for the help!

[Brad Bowman · Accepted solution]

I think this is more along the lines of what you are looking for:

[rcoleTCS555]

Thanks! That helped 🙂

[Brad Bowman]

You are welcome!