We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Way to extract user info based on user roles? [Answered] | Forum

Topic location: Forum home » Support » General Questions
Christer
Christer Oct 8 '15
I got tips here before how to get user out from DB but that is all info about users and that great but I try now to just extract a  user role so lets say I want to extract all VIP customers and I want there email and user name, How can I do that? Try to find in DB but not find any roles specified.
i thought maybe as massmailing I can set based on a user role it should be some were for me to extract bút no luck. Any one have idea how to do this?
The Forum post is edited by Taissa Oct 8 '15
Taissa Team
Taissa Oct 8 '15
Christer, there is no such default functionality in our software. As an option I can suggest you to manage this issue via database. This is considered as custom code modification and I can not provide you with detailed instructions. All I can just show you the direction.  You should write and  execute an SQL query using these database tables:
ow_base_authorization_role,
ow_base_authorization_user_role,
ow_base_user.

If you are not familiar with the code modification, it would be better for you to find a developer who can help you. You can do it here: http://www.oxwall.org/market/.
Christer
Christer Oct 8 '15
ok thanks I see if I can find some one to do this