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 department search listingMember directory department search listing
Previous
 
Next
New Post
5/1/2013 10:16 PM
 

I'm trying to implement a department search listing with the existing member directory module.  In a separate module, there would be a list of the departments and you can click on a department which will then filter the member directory to show just the members from that department.

 
New Post
5/23/2013 5:52 AM
 
U can use the reports module for this. First click on host then sql add 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

into the sql and press enter.
next go to a page and add the reports module. then click on settings and enter this into the sql assuming that the custom profile field that you made is named Department if it is not change everywhere below that says department and add the name of the department where it says to
SELECT
u.UserName,
u.FirstName,
u.LastName,
u.Email,
department.PropertyValue AS department
FROM
dbo.udf_UserProfileField('department') AS department left OUTER JOIN dbo.vw_Users AS U on department.PortalId = U.PortalId AND departmentl.UserID = U.UserId and department.PropertyValue = 'Department name exactly as it is from the drop down list '
click test and if it comes back ok you are good to go.
Now scroll down to active visualizer and select grid. and ckeck the box for sorting and press save.
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Member directory department search listingMember directory department search listing


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