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
 

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

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