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

Forum

Forums > DotNetNuke® > DotNetNuke® Questions
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:5352
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:5306
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:5306
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: while installing bulk emailer module in my website by dub
Agiline, We have seen this problem before. It is caused by the Security on IIS. Please have a loo...
RE: Change Registration Redirect? by ollep
Probably still want to do it with Dynamic Forms now.My reason for changing (except from getting Aweb...
RE: Change Registration Redirect? by ollep
YES!http://www.dnncreative.com/Subscribe/tabid/81/Default.aspx
RE: Change Registration Redirect? by ollep
Yes I noticed that we where talking about 2 different Modules as soon as I dug into the tutorials.Ab...
RE: Change Registration Redirect? by leesykes
If you are check out the links that I have placed in there:http://www.dnncreative.com/Subscribe/tabi...
RE: Change Registration Redirect? by leesykes
Are you referring to when subscribing there is a link to register and after they register it sends t...
RE: Change Registration Redirect? by leesykes
The method I use on here for managing my email list is complicated and involves SQL queries, it is b...
Ecommerce module needed by vishalranaut
Infyecommerce is providing ecommerce packages for the clients to develop their ecommerce sites.They ...
RE: DS Dynamic Forms / AWeber by leesykes
If you are getting time out issues when installing I would use the auto install method by using FTP,...
RE: Change Registration Redirect? by ollep
Oooops Helps reading your responses before posting here Lee. I referred to Issue 40 / 41 and ...
DS Dynamic Forms / AWeber by ollep
Thanks for a great Tutorial Lee!  - As usual.(I still can't install the module in Firefox though, Fi...
while installing bulk emailer module in my website by agiline
Hi all,i have downloaded bulk e mailer trial version and when i am installing it in my website it wa...
RE: Creating Portals before setting the host by cyborama
Hello Joe, Just got done speaking with my hosting company in reguards to A records and host head...
RE: PayFlow Link by johnmurphy
Hi murphydolores, I am using iHost. iHost.Net supports PayFlow Link and its easy to configure. T...
RE: Background Music by cyborama
Hello Kyle I can't think of any modules that could do this though that doesn't mean they are not out...
RE: Creating Portals before setting the host by cyborama
Hello Joe thanks for the quick reply, If you read down my thread fully you will see I had already...
RE: Employee Absent Indicator by jncraig
I think that the biggest here is to define the workflow and to figure out who/how will maintain the ...
RE: Run exe/dll from DNN? by ollivogt
Thank you. I have a look at it....RegardsOliver
RE: DotNetNuke 5.3.0 Released by jncraig
Whoops! From Joe Brinkman: "With any software product you will occasionally have a release tha...
RE: Creating Portals before setting the host by jncraig
Whoops! Didn't quite finish. DNS, through A Records and other records is used to convert a domai...
DotNetNuke Modules
RSS Feeds