Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Member directory Not showing usersMember directory Not showing users
Previous
 
Next
New Post
7/5/2013 6:14 AM
 
Rudy

www.itbizzness.com
Joined: 7/19/2005
Posts: 58

Hi, I have upgraded my DNN  version to DNN 7.05. The reason was the use of the Member directory Module. The system has 400 users and I have added them with a bulk import. Then we changed the profiles of the users with some custom fields.

The member directory was needed to I can show filters users based on a custom field.

Unfortunately, when I filter on lastname it wil only show superuser (1 account) and nothing else. Any other filter lets the module show nothing and it wil display loading for hours. Not error message in the logfile and no errors in IIS. When I take the filters off and take the default setting then all I get is the superuser account.

Is the module able to work with custom fields? I have no idea were to look for this problem.

Rudy
 
New Post
11/18/2013 5:03 AM
 
Dodgefate


Joined: 4/20/2013
Posts: 137
From my experience I would say no. but you could use the reports module to pull the persons info I do and then you can set it to pull other information like username to help you find the person. there is a thread on dnncreative that tells you the sql you need to insert first, I just cant find it now... but if you do here is an examp0le of what my sql select statement looks like:
SELECT
u.FirstName,
u.LastName,
u.Email,
Telephone.PropertyValue As Telephone,
Committee.PropertyValue AS Committee
FROM
dbo.udf_UserProfileField('Telephone') AS Telephone left OUTER JOIN dbo.vw_Users AS U ON U.UserId = Telephone.UserID AND U.PortalId = Telephone.PortalId
join
dbo.udf_UserProfileField('Committee') AS Committee ON U.UserId = Committee.UserID AND U.PortalId = Committee.PortalId
Where Committee.PropertyValue >' ' ORDER BY Committee
 
New Post
11/18/2013 5:22 AM
 
Dodgefate


Joined: 4/20/2013
Posts: 137
found the script you need to insert into your sql. I wish I could find the programer that wrote it to give him credit. After trying this if you need help writing your sql script send me a message I have gooten better at it. Start by going to host then click on sql and cut and paste the below:

CREATE FUNCTION [dbo].[udf_UserProfileField]
(
@PropertyName NVARCHAR(50)
)
RETURNS @ProfileFieldTable TABLE
(
PortalId INT,
UserID INT,
PropertyName NVARCHAR(50),
PropertyValue NVARCHAR(3750)
)
AS BEGIN
INSERT INTO @ProfileFieldTable
SELECT PPD.PortalID,
UP.UserID,
PPD.PropertyName,
UP.PropertyValue
FROM dbo.Users AS U
INNER JOIN dbo.UserProfile AS UP ON U.UserID = UP.UserID
INNER JOIN dbo.ProfilePropertyDefinition AS PPD ON UP.PropertyDefinitionID = PPD.PropertyDefinitionID
WHERE ( PPD.PropertyName = @PropertyName )

RETURN
END
 
 Page 1 of 1
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Member directory Not showing usersMember directory Not showing users


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