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!
Previous
 
Next
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 mitchelsellers.com for my mostly DNN Blog and support forum.

Visit IowaComputerGurus.com 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:

SELECT
u.UserName,
u.FirstName,
u.LastName,
u.Email,
Numerical.PropertyValue AS Numerical,
Street.PropertyValue AS Street,
Telephone.PropertyValue As Telephone,
Committee.PropertyValue AS Committee,
Volunteer.PropertyValue as Volunteer
FROM
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 >= ' '

 

 
Previous
 
Next
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.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out