Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (6)

Resolved How to set a Filter?

  1. galbur
    galbur
  2. Support
  3. Friday, November 06 2015, 10:16 AM
Hi

On Your Webiste you have the Member-List-Tab with some Search-Filters.
How can i build a Filter for a specific field? (Checkbox-List)
Is it possible to build filters with a dropdown menu?

Thank you
Attachments (1)
printscreen.png printscreen.png
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
- Go to Components->Easy Profile and choose which fields are available for search (screenshot1)
- Go to Menu manager and create/choose a menu item of type Easy Profile->Users List or Easy Profile->Users Table
- In menu item parameters go into "Search" section (screenshot2)
- Set parameters like
Enable Search: Yes
Fields to search: Name,Ort,Member ID, Interests
Attachments (2)
screenshot1.png screenshot1.png
screenshot2.png screenshot2.png
  1. more than a month ago
  2. Support
  3. # Permalink
Responses (6)
admin
admin Accepted Answer
Admin
Hi,
you can create a menu item of type "Users List" or "Users table", in parameters you will find a options for search, try to read docs at http://docs.easy-profile.com/index.php/article/users-listsearch

You can set also a static filter with parameter called "SQL Custom Where" to see in this list only users with predefined requisites. for example you can create a list for each usergroup, for more info read docs at http://docs.easy-profile.com/article/sql-custom-where
  1. more than a month ago
  2. Support
  3. # 1
galbur
galbur Accepted Answer
Ok, Thank you

I read the Documentations but i was not able to build something like this:
  1. more than a month ago
  2. Support
  3. # 2
galbur
galbur Accepted Answer
Thank you very much!
Perfect, that works.

Chris
  1. more than a month ago
  2. Support
  3. # 3
motionpixels
motionpixels Accepted Answer
Hi,
Is it possible to have a menu item that shows a user list off all users that have INTEREST = TENNIS? So you (the website builder) predefine the search criterium already in the menu settings ...

So the user does not see the search fields ...... But the result is a list of all users that like tennis.
  1. more than a month ago
  2. Support
  3. # 4
admin
admin Accepted Answer
Admin
Yes, you can use SQL Custom Field parameter (docs at http://docs.easy-profile.com/article/sql-custom-where)

IMPORTANT: checkbox allow to have a multi-values, so the value is stored into JSON format, you need to use syntax like this:
interest LIKE '%"tennis"%'


JSON format store values like
["music","art","design"]


SQL custom where is a very powerful parameter, you can put all SQL commands.
  1. more than a month ago
  2. Support
  3. # 5
motionpixels
motionpixels Accepted Answer
Great. I will look into this.
Thank you for the very very fast answer!

Robert
  1. more than a month ago
  2. Support
  3. # 6
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.