Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...user account list ?user account list ?
Previous
 
Next
New Post
5/20/2009 4:28 AM
 

Hello,

I need help because I don't find the answer in books or on the net. I'm building extranet with ddn. Each user has one account with details but how is it possible to have a list of all registred users with details in a module. Which module can I use for that ? I'm very lost and it's very important. Thanks

 
New Post
5/20/2009 5:24 PM
 

david-
You can get what you need with the core REPORTS module (or any of several third party modules including some free ones).  However, you need to supply the right SQL query for the data you desire.
 
To see a basic info list of all users on a site, drop the REPORTS module on a page and, in the module SETTINGS, add the following SQL query:
 
select * from users u
inner join userportals usp
on u.userid = usp.userid
where usp.portalid = @portalID

 
Easy enough, but you probably don't want to show who is a SuperUser, who has their password set to force an update on next login (UpdatePassword), etc.
 
Let's say you only wanted to show names, usernames and email addresses.  For that, use the following query:
 
select 
FirstName+' '+LastName as Name,
Username as Username,
Email as Email
from users u
inner join userportals usp
on u.userid = usp.userid
where usp.portalid = @portalID


If you wanted to show other user data not included in the USERS and USERPORTAL tables, you'd need additional "join" clauses with the appropriate tables.  For instance, you could join with the appropriate Blog module table to show whether a user has a blog or join with the appropriate Forums module table to show how many forum postings each user has submitted.  Creating your own queries in this manner is very powerful (and free).  The down side is that you need to know what database tables hold what info and know how to create the proper queries to extract the desired data.
 
You might also be interested in these (relatively) simple examples which can readily be used in the REPORTS module by substituting REPORTS module tokens (such as "@portalID") in place of the custom module tokens (such as "[PortalID]") shown in the examples:
 
   Free DNN Module:  Advanced Datagrid Part 1 (create list of most recent user signups)
   http://www.eguanasolutions.com/DNN_Blog/EntryID/2.aspx
 
   Free DNN Module:   Advanced Datagrid Part 2 (add an events"status table" for the DNN EVENTS module)
   http://www.eguanasolutions.com/DNN_Blog/EntryID/5.aspx
 
   Free DNN Module:  Advanced Datagrid Part 3 (create a clickable "most-commented blogs" list)
   http://www.eguanasolutions.com/DNN_Blog/EntryID/13.aspx

   Free DNN Module:  SQLView (sort EVENTS module events by City / County / State)
   http://www.eguanasolutions.com/DNN_Blog/EntryID/15.aspx
 
   Quickly create a Tag Cloud with the REPORTS module
   http://www.eguanasolutions.com/DNN_Blog/EntryID/33.aspx
 

Cheers!
-mamlin


esmamlin atxgeek.me
 
New Post
7/15/2009 9:59 AM
 

Hello,

Thanks a lot for information but I need something different from that.

I hope that somebody can help, I have written this :

SELECT PropertyValue

FROM UserProfile

WHERE

PropertyDefinitionID IN ('21','23','26','27','30','31','32')

and visibility=1

order by userid, propertydefinitionid

Here, I have all the informations that I need from each user but each part is on a different line and I need all the informations from the same user on one line. What can I do ?

I need that :

Nickname, name, adress,city,postal code, phone, mobile

and I have this :

Nickname
Name
adress
city
postal code
phone
mobile
 
 
 
 
 
 
 

PLEASE Help me ... thanks a lot

 
New Post
7/15/2009 12:23 PM
 

David,

check out free UserDirectory module  it allows list and detail view, search, filter and a couple of other features.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
7/15/2009 3:04 PM
 

david-
Do yYou need all on one line per user just for page layout / readability or because you need to import the data into a spreadsheet?
 
-mamlin


esmamlin atxgeek.me
 
Previous
 
Next
HomeHomeDevelopment and...Development and...DNN Platform (o...DNN Platform (o...user account list ?user account list ?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out