> Forums > Active Social > Themes and Templates > Need help filtering members with query
Last Post 15 Apr 2010 05:40 AM by MHuijbregts. 9 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
odove
Customers
odove
Post Count:114

--
04 Mar 2010 11:46 AM
    I need help filtering member directory :

     "Filter - Enter a predefined query to filter the member list. "

    How this query should look like? For example, I want to have a page that displays female members only, the users have selected their gender during the registration.  I would like to see some sample query for this.   Any help is much appreciated.



    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    05 Mar 2010 02:19 AM
    Assuming the name of the profile field is Gender and the value stored for female is 'Female', you would enter something like this...

    Gender='Female'
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    odove
    Customers
    odove
    Post Count:114

    --
    05 Mar 2010 11:13 AM
    Thanks a lot for the help. Now I can get stuff filtered perfectly.
    Ray Dixon
    Customers
    Ray Dixon
    Post Count:199

    --
    29 Mar 2010 06:27 PM
    Is it possible to set the filter so the Member Directory view only shows users in a specific role? If so, how? For instance, I want to create a Member Directory view that only shows users in the Board of Directors role.
    Caleb Hanson
    Customers
    Caleb Hanson
    Post Count:69

    --
    30 Mar 2010 12:42 PM
    I need to do the same thing as Ray, filter by role.
    Caleb Hanson
    Customers
    Caleb Hanson
    Post Count:69

    --
    07 Apr 2010 01:20 PM
    Bump
    Will Morgenweck Forum Admin
    DotNetNuke Staff
    Will Morgenweck
    Post Count:7672

    --
    14 Apr 2010 04:48 PM
    You will be able to filter by role id in 1.6.
    Will Morgenweck
    Director of Product Management
    DotNetNuke Corp.
    Ray Dixon
    Customers
    Ray Dixon
    Post Count:199

    --
    14 Apr 2010 04:59 PM
    That's great news. Thanks, Will!
    DavidE
    Customers
    DavidE
    Post Count:106

    --
    15 Apr 2010 02:03 AM
    Very good news - I just came across this requirement a few days ago in my implementation and the ability to filter by roleID will solve that scenario perfectly.
    MHuijbregts
    Customers
    MHuijbregts
    Post Count:1248

    --
    15 Apr 2010 05:40 AM
    You will be able to filter by role id in 1.6.


    Sounds great!!
    Regards,
    Marc
    www.biservices.eu for free nl-NL resourcepacks (Incl. Active Forums & Active Social)
    You are not authorized to post a reply.
    > Forums > Active Social > Themes and Templates > Need help filtering members with query
    test
    Copyright 2012 by DotNetNuke Corporation / Terms of Use / Privacy