Corporate Site | Register |

R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Unanswered Active Topics Forums Search Members
Forums > Bi4ce.Modules > GoMap (free module)
How do I show all users based on a role
Last Post 01 Jan 1900 05:00 AM by . 1 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
chaloumUser is Offline
New Member
New Member
Posts:8

--
25 Oct 2007 12:45 PM  
Does anyone know how to get GoMaps to show all location of users that belong to a Role?

thanks
ewalkerUser is Offline
Basic Member
Basic Member
Posts:221

--
25 Oct 2007 01:44 PM  
Hi chaloum,

Take a look at the SQL view vwPeopleOnline that is added to DNN by GoMap. If you join this view against the UserRoles and Roles tables to filter on a Role name, you will have a view that shows users belonging to that certain role.

The new view that you create will automatically show up in the dropdown for GoMap views/tables if you keep the same columns in the output that vwPeopleOnline returns.

Thanks,
-Eric
Eric Walker - R2integrated
You are not authorized to post a reply.
Forums > Bi4ce.Modules > GoMap (free module)
Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share
© 2012 R2integrated. All Rights Reserved.