1. sergio0187
  2. General
  3. Saturday, April 08 2017, 03:01 PM
Hi,
I would like to have a selection of members by year which paid.
Attached you find a printscreen of my table and a printscreen of the custom field selection tab.

I don't know how to use that tab for this and hope you can help!

Kind regards
Attachments (1)
admin Accepted Answer
Admin
Hi,
sorry but I not understand. Can you explain with an example which options you would have in the select field?

I would like to have a selection of members by year which paid.
Sorry but this is not clear, from your screenshot you seems to try to configure options for a select field type (not a filter for the user list).
  1. more than a month ago
  2. General
  3. # 1
sergio0187 Accepted Answer
Pro
Hi,
Thank you for support.

The Joomla users have a membership. The membership data is stored in another table but the joomla userid is in that table too.
I was wondering if I could just filter the easy profile users by the membership data in that other table.

In that other table there are 3 columns: membership year, if membership is paid and user id.

I would like to have a filter in easy profile user list with membership. And the selector items would be the membership year.

Hope you can help!
  1. more than a month ago
  2. General
  3. # 2
admin Accepted Answer
Admin
Hi,
sorry but you can't create a select field that filter users based on data from another component/table.

You can only create different Users Lists (menu items) and set filters (Custom SQL WHERE) that check data from another table.

At http://docs.easy-profile.com/article/sql-custom-where you will see some example.
In your case you can see section "Online Users", you will see a SQL Where that include user_id from Joomla session table, so
For 2016 menu item the SQL Where should be

user_id IN (SELECT DISTINCT userID FROM #__dashboard_membership WHERE endDate = "2016-12-31 00:00:00" AND isPaid = 1)

For 2017 menu item the SQL Where should be

user_id IN (SELECT DISTINCT userID FROM #__dashboard_membership WHERE endDate = "2017-12-31 00:00:00" AND isPaid = 1)


this is only an example but SQL syntax allow you to create dynamic lists like:
- Paid users this year

user_id IN (SELECT DISTINCT userID FROM #__dashboard_membership WHERE YEAR(endDate) = YEAR( CURDATE() ) AND isPaid = 1)

- Paid users last year

user_id IN (SELECT DISTINCT userID FROM #__dashboard_membership WHERE YEAR(endDate) = YEAR( DATE_SUB( CURDATE(), INTERVAL 1 YEAR) ) AND isPaid = 1)

- Paid users 2 years ago

user_id IN (SELECT DISTINCT userID FROM #__dashboard_membership WHERE YEAR(endDate) = YEAR( DATE_SUB( CURDATE(), INTERVAL 2 YEAR) ) AND isPaid = 1)
  1. more than a month ago
  2. General
  3. # 3
sergio0187 Accepted Answer
Pro
Thank you so much!!

Can Easy Profile get this feature to include in future versions to have fields from other tables like I suggested?

I will use your suggestions, thanks again!
  1. more than a month ago
  2. General
  3. # 4
  • Page :
  • 1


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