Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Sunday 5:37 am
Add a reply View Replies (9)

Resolved Search for members who not pay annually fee

  1. duro-jelecevic
    duro-jelecevic
  2. General
  3. Thursday, March 02 2017, 11:57 PM
Hi,

I'm currently in the process of making a website with a list of members. Members pay dues annually. I want to create a checkbox with age, for example.

0 | 2015
1 | 2014
2 | 2013
3 | 2012
4 | 2011
5 | 2010

and when a member pays a membership fee for 2014 I go to user profile and mark 2014 and it is stored in a database. However, when I want to search members I want to show members who have not paid for a given year. For example, in search modules I have checbox with 2015, 2014, 2013 and so on, and when I mark a 2014 I want to show members who have not paid for that year.

Do you have any idea how to do it. Thank you.

Btw. Your component is awsome.
  1. checkbox
Responses (9)
admin
admin Accepted Answer
Admin
Hi,
this is not possible with a simple way, but there is a simple alternative: you can create 6 menu items with a different static filters (Custom SQL Where).

Menu item "User not paid 2010"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"5"%'

Menu item "User not paid 2011"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"4"%'

Menu item "User not paid 2012"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"3"%'

Menu item "User not paid 2013"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"2"%'

Menu item "User not paid 2014"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"1"%'

Menu item "User not paid 2015"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%"0"%'

You can put these menu item in special menu visible only on these menu items (see screenshot)

Docs about Custom SQL Where at http://docs.easy-profile.com/article/sql-custom-where
Attachments (1)
Schermata 2017-03-03 alle 09.22.33.png Schermata 2017-03-03 alle 09.22.33.png
  1. more than a month ago
  2. General
  3. # 1
duro-jelecevic
duro-jelecevic Accepted Answer
Does not work. Say 0 Users Found.
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
please check that "alias_of_checkbox" is the correct alias of your checkbox field.

or try without quotes, so become something like this:
Menu item "User not paid 2010"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%5%'

Menu item "User not paid 2011"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%4%'

Menu item "User not paid 2012"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%3%'

Menu item "User not paid 2013"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%2%'

Menu item "User not paid 2014"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%1%'

Menu item "User not paid 2015"
- Custom SQL Where: alias_of_checkbox NOT LIKE '%0%'
  1. more than a month ago
  2. General
  3. # 3
duro-jelecevic
duro-jelecevic Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
done and fixed, your checkbox field is called "test" (with alias "test1" ) so you Custom SQL Where should be:

Menu item "User not paid 2010"
- Custom SQL Where: test1 NOT LIKE '%"5"%'

Menu item "User not paid 2011"
- Custom SQL Where: test1 NOT LIKE '%"4"%'

Menu item "User not paid 2012"
- Custom SQL Where: test1 NOT LIKE '%"3"%'

Menu item "User not paid 2013"
- Custom SQL Where: test1 NOT LIKE '%"2"%'

Menu item "User not paid 2014"
- Custom SQL Where: test1 NOT LIKE '%"1"%'

Menu item "User not paid 2015"
- Custom SQL Where: test1 NOT LIKE '%"0"%'
  1. more than a month ago
  2. General
  3. # 5
duro-jelecevic
duro-jelecevic Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 6
duro-jelecevic
duro-jelecevic Accepted Answer
Why AJAX feature does not work when I press for example 2014. I enable AJAX in menu options (see picture).
  1. more than a month ago
  2. General
  3. # 7
admin
admin Accepted Answer
Admin
Hi,
this is normal because this is an alternative, each link load a new menu item and does not filter users like search module.
  1. more than a month ago
  2. General
  3. # 8
duro-jelecevic
duro-jelecevic Accepted Answer
OK.
  1. more than a month ago
  2. General
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.