Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting Solutions
FCKeditor Project
Salaro -- Skins and more
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Role Users Report
Previous Previous
 
Next Next
New Post 3/26/2008 2:48 PM
User is offline dmoore
5 posts
10th Ranked


Re: Role Users Report 

This post was extremely helpful and nearly gave me everything I needed! But I need to take it to the next level:

I have created some custom Profile Properties for alumni of our institution so graduates can give more details about themselves. I have no idea how to query the database to get those specific returns. I tried using the following (I changed the "31" and the "PhoneNum": 
(SELECT PropertyValue FROM UserProfile WHERE
    UserProfile.UserID = U.UserID AND
    UserProfile.PropertyDefinitionID = 31) As PhoneNum

How can I find out the PropertyDefinitionID for a specific column in the database? Where is this detail found? I randomly tried many different numbers, and while the query worked, it didn't return a result for that column...

I need to provide our alumni coordinator with a report that provides all the users in the alumni role along with all their personal data they have entered in the custom profile fields I created...

Any help would be greatly appreciated! You guys are awesome!
 
New Post 3/27/2008 2:22 PM
User is offline Fuji Nguyen
192 posts
9th Ranked




Re: Role Users Report 

The profile definitions are stored in table ProfilePropertyDefinition.  The script below will list em all

SELECT    *
FROM         ProfilePropertyDefinition

Fuji Nguyen
FREE Visitor Hit Counter
Visit opensource.indyneinc.com for detail.
 
 Page 3 of 3Previous123 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Role Users Report
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Softech Development, Inc.
We help your business work smarter with DotNetNuke. Whether you need a new implementation, a custom module or skin for an existing implementation, or integration with your business processes, Softech has the experience and expertise to make it happen.
www.softechdevelopment.com 		Module Development by Engage Software
Specializing in custom module development, training and skinning.
www.engagesoftware.com 		BataviaSoft DotNetNuke Solutions
BataviaSoft offers custom DotNetNuke solutions especially for the European and the South East Asian market.
www.bataviasoft.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP