kennyp/no_role.rb

Created March 10, 2014 15:07

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/kennyp/9466742.js"></script>
Save kennyp/9466742 to your computer and use it in GitHub Desktop.

Download ZIP

Users without a role.

Raw

Spree::User.joins('LEFT JOIN "spree_roles_users" ON "spree_roles_users"."user_id" = "spree_users"."id" LEFT JOIN "spree_roles" ON "spree_roles"."id" = "spree_roles_users"."role_id"').group('spree_users.id').having('count(spree_roles.id) = 0')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment