Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

View of all users with no assigned role #1112

Open
john opened this issue Nov 6, 2018 · 0 comments
Open

View of all users with no assigned role #1112

john opened this issue Nov 6, 2018 · 0 comments
Milestone

Comments

@john
Copy link
Owner

john commented Nov 6, 2018

Related #1086

Show results of this, with option to assign them as an unapproved driver to an RZ:
SELECT u.id, u.name FROM users u WHERE id NOT IN (SELECT ur.user_id FROM users_roles ur);

@john john added this to the Post election milestone Nov 6, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant