Learn More





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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Looking to locate Authorized column not approved column Driving me insane!Looking to locate Authorized column not approved column Driving me insane!
New Post
5/18/2013 9:07 PM
Hi all and thanks for taking the time to read. I am working on a report in the reports module and I want it to only show Authorized members(authorized accounts that have been approved by admins).  I have searched around online and can find the Approved column by this:

SELECT dbo.aspnet_Membership.IsApproved  FROM dbo.aspnet_Membership

But that is not what I am looking for. It shows all as true when I have two test accounts set up that are not authorized.  I can not find where the Authorized Column is located and it is driving me nuts! I am using:

DotNetNuke Community Edition

05.06.02 (144)

I am actuly loosing sleep over this and I have select blablabla from blablabla running through my head all the time now!

New Post
5/19/2013 6:23 PM
Try "Authorized" on the UserPortals table for the specific userid and portal.

-Mitchel Sellers
Microsoft C# MVP, MCITP
CEO/Director of Development - IowaComputerGurus Inc.
LinkedIn Profile

Visit for my mostly DNN Blog and support forum.

Visit for free DNN Modules, DNN Performance Tips, DNN Consulting Quotes, and DNN Technical Support Services
New Post
5/20/2013 5:21 AM
Mitchel, I tried your expression and it did not work so I tried select * from dbo.UserPortals and found out the column was named Authorised. so my new statement reads: select Authorised from

dbo.UserPortals where Authorised='true' 

I can not thank you enough for giving me the container (guess that is what it is called)  dbo.UserPortals

If you have time, sorry probably should have said this is a two part question, and that I am kind of new to this how do I now add:

select Authorised from

dbo.UserPortals where Authorised='true'

to my current statement (which I know works) of:

Numerical.PropertyValue AS Numerical,
Street.PropertyValue AS Street,
Telephone.PropertyValue As Telephone,
Committee.PropertyValue AS Committee,
Volunteer.PropertyValue as Volunteer
dbo.udf_UserProfileField('unit') AS Numerical left OUTER JOIN dbo.vw_Users AS U on Numerical.PortalId = U.PortalId AND Numerical.UserID = U.UserId and Numerical.PropertyValue >= ' '  join
dbo.udf_UserProfileField('street') AS Street ON U.UserId = Street.UserID AND U.PortalId = Street.PortalId  and Street.PropertyValue >= ' ' join
dbo.udf_UserProfileField('Telephone') AS Telephone ON U.UserId = Telephone.UserID AND U.PortalId = Telephone.PortalId and Telephone.PropertyValue >= ' ' join
dbo.udf_UserProfileField('Committee') AS Committee ON U.UserId = Committee.UserID AND U.PortalId = Committee.PortalId  and Committee.PropertyValue >= ' ' Join
dbo.udf_UserProfileField('Volunteer') AS Volunteer on U.UserId = Volunteer.UserID AND U.PortalId = Volunteer.PortalId
 and volunteer.PropertyValue >= ' '


HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Looking to locate Authorized column not approved column Driving me insane!Looking to locate Authorized column not approved column Driving me insane!

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.
Try Evoq
For Free
Start Free Trial
a Demo
See Evoq Live
Need More Information?