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  |  

telerik -- supercharge your DNN websites
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
 


  Sponsors  

Meet Our Sponsors

Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
 


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.
 


DotNetNuke Hosting Provider UK
UK leading DotNetNuke Hosting provider. Owned and operated by a Microsoft Gold Certified Partner.
www.DNN-Portals.co.uk 		Alliance Systems & Programming Inc
Alliance is not just our name... it's how we do business. We partner with our clients, learning their business processes and standards and then applying our expertise to help them improve their workflow and profitability.
www.Alliancesys.com 		Customer Connect
Customer Connect provides cutting edge solutions that deliver sales, marketing and customer service results.
www.customer-connect.com

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