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)

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
# 1

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
# 2

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
# 3

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