Not signed in (Sign In)

Categories

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.

Help keep Vanilla free:
Welcome Guest!
Want to take part in these discussions? If you have an account, sign in now.
If you don't have an account, apply for one now.

General Support & Troubleshooting: listing users with an specific rol

Bottom of Page

1 to 7 of 7

  1.  
    • CommentAuthorargie01
    • CommentTimeDec 18th 2007
     # 1
    Hi,

    is there a way to list all the users that belong to an specific rol?

    Thank you!
  2.  # 2
    Try using the advanced search.
    • CommentAuthorargie01
    • CommentTimeDec 20th 2007
     # 3
    Thank you very much!
    • CommentAuthorargie01
    • CommentTimeDec 20th 2007
     # 4
    Anybody could give an sql query code to execute in my phpmyadmin and get a listing of members that belong to an specific rol?
    The problem with the advance search is that I have to do a copy/paste for each name of user to get a list of them...

    Thank you!
  5.  # 5
    SELECT 'Name' FROM 'LUM_USER' WHERE 'RoleID'=4;
    Should work I think... change the 4 for whichever ID you need. You can find them in the LUM_Role table.
  6.  # 6
    SELECT u.UserID, u.Name, r.Name, u.FirstName, u.LastName, u.Email
    FROM LUM_User AS u,
    LEFT JOIN LUM_Role AS r USING RoleID
    WHERE r.Name = 'Banned';
    You can change the WHERE clause to r.RoleID = '1' and select by the RoleID if you know that, or leave it as-is and use the Role Name. The query will show the User Name, Real Full Name, Email Address, User ID, and Role Name.

    What exactly are you trying to do? The advanced search in Vanilla is pretty powerful and will show all users in a single so you shouldn't have to use this query.
    • CommentAuthorargie01
    • CommentTimeDec 21st 2007
     # 7
    Thank you!!

    I know the advanced search is useful to do it. But I need a listing of user of a rol, and if I use the advanced search I should copy/paste for each user returned to an excel. Instead it, by using an sql query I do not need to copy/paste for each user, because I just need 1 copy/paste :)

1 to 7 of 7

  1.  
Add your comments
    Username Password
  • Format comments as
 
Back to Discussions Top of Page