Easy Profile - Joomla Extension

Support

Resolved database data in custom select field

sergio0187
General
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

Responses (4)

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).

more than a month ago
General
# 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!

more than a month ago
General
# 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)

more than a month ago
General
# 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!

more than a month ago
General
# 4

Page :
1

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

Please login to post a reply

You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »

Forgot Password?

Request Support

Ask a Question

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.