You need to Register for free and Login to post a message in the forum.

Forum

Subject: Tokens associated with specific users
Prev Next
You are not authorized to post a reply.

Author Messages
Knut Erik
Nuke Active Member
Nuke Active Member
Posts:33

01 Jul 2009 8:16 AM  
Hello, Is there any way of using tokens associated with specific users, not only the user who is currently logged in? Instead of [User:Email], I would like to have [John:Email], for example. The reason I want this is that I would like to have a dynamically updated E-mail list on my site, so that when a user changes his email-adress, the list changes accordingly. Maybe there is another way of accomplishing this? Thanks for any advice, Knut Erik
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5327


01 Jul 2009 8:08 PM  
If you want to create a list of users with their email addresses, I'd recommend using the Reports module. It will build the list dynamically whenever you visit the page that contains it.


Joe Craig
DNN Creative Support
Subscribe to the website
Knut Erik
Nuke Active Member
Nuke Active Member
Posts:33

02 Jul 2009 8:10 AM  
Joe, Thanks. I'm new to SQL. Would you happen to know what I should write in the query field to list Display Names and Email addresses for all users in a specific role? I have figured out how to do this for all the users, but not when I want just those who are members of a specific role. I would also like to sort the users alphabetically by Display Name, if that is possible. Thanks for your help, Knut Erik
Lee Sykes
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5287


03 Jul 2009 2:08 AM  
I use this for selecting username, first, last name, email, role id and role name

SELECT Users.UserID, Username, FirstName, LastName, Email, UserRoles.RoleID, Roles.RoleName
FROM         Users INNER JOIN
                      UserRoles ON Users.UserID = UserRoles.UserID INNER JOIN
                      Roles ON UserRoles.RoleID = Roles.RoleID
WHERE     (UserRoles.RoleID = 3)

You will see the where clause is where Role id = 3, this is the newsetter security role on my site, you will need to look at the Roles table to see the id for the RoleName you require.

Or alternatively, just run the query and keep changing the roleid number until you find the correct one as it will display the role name in the results

Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
Lee Sykes
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5287


03 Jul 2009 2:09 AM  
ps. you may want to check out these tutorials:


Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
Knut Erik
Nuke Active Member
Nuke Active Member
Posts:33

03 Jul 2009 3:04 AM  
Fantastic! Just what I needed. You saved me a lot of time, as I am in a hurry to finish this before I leave on vacation. You have been very helpful. Thank you so much.
You are not authorized to post a reply.
Forums > DotNetNuke® > DotNetNuke® Questions > Tokens associated with specific users



ActiveForums 3.7

Latest Forum Posts

RE: Creating Portals before setting the host by cyborama
Thanks for the reply Joe, The way my hosting company does things they don't have per say host hea...
RE: Flash in the HTML Module by robmacker
Wow, why does the forum format my question to make it basically unreadable?? I certainly did not typ...
Flash in the HTML Module by robmacker
Hello members! I have a simple flash application that was written for an HTML page and i'm trying...
Send email with Dynamic Forms Results by jesp17
Hello, Is there a way to automatically generate a report with all form results and then send this r...
Community Edition Question by idesofmarch
I'm learning a lot just browsing around here. Wish I could delete my question below. Oh well. Wher...
RE: DNN Site crashed after module install by mcmanta
I found a work around. Looks like the module replaces the Telerik.Web.UI located in the bin folder o...
RE: iHostASP by chandirika
Hi,I am reselling account with this http://www.goresellers.com/ site ,for my web site's web hosting...
the now content not showing and still showing the old one by wael_e
after i uploading the new contenct in my website and i uploading static html page have introdaction ...
RE: Regular Expression by jumatthey
Hi, Thank you very much Mark. It is indeed a name I am checking. Thank you for your help, very mu...
RE: How to do links? by Guy..L
I think this website is properly structured in that I can drop the requirement to exclude certain pa...
RE: Nav Menu v2 for DotNetNuke v5 - Issue 52 by kparker
What are the advantages of setting the RenderMode to UnorderedList for the Nav Menu? How can this b...
RE: DNN Site crashed after module install by jncraig
Most likely, the module that you installed uses a Telerik library that is different from the one tha...
DNN Site crashed after module install by mcmanta
Hello All,I'm using DNN 5.2.3 after install everything was working fine. I installed the 365 Simple ...
Fun? with styling of Home.aspx by dkemp@karrtuttle.com
I asked my assistant to create a page for me and pursue an idea that I had for our intranet.  I thou...
Using Xenu Link Sleuth to Spot and Improve External Links in a Domain by Sh@wn
Hi,I have used this (useful) program in my dnn website and I have seen several page not found errors...
RE: Change Registration Redirect? by ollep
Thanks guys! So what are you using on this site?? Looks pretty much like the standard DNN regist...
RE: Regular Expression by MarkXA
Hi, For the case in point ValidationExpression="^[a-zA-z-' ]*$" should do it. I've added the hyph...
RE: Regular Expression by MarkXA
Hi, For the case in point ValidationExpression="^[a-zA-z-' ]*$" should do it. I've added the hyph...
How to slow down the menu by datamark
Can you tell me how to slow down the solpart menu so that the mouse user can be a bit more sloppy ab...
RE: How to do links? by Guy..L
It's a fine line between being too automatic and being too configurable.  It's awesome if Nav 2 indi...
DNM Rapid Application Developer Trial Version
RSS Feeds