Support

    You are here:  
  1. Home
  2. Support
  3. Badges
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
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.

Request Support

Support is currently Online
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.