- Posts: 6
- Thank you received: 0
Active subscribers shown in expired list
- Francis Bartucca
- Topic Author
- Away
- New Member
-
Less
More
2 months 3 weeks ago #157191
by Francis Bartucca
Active subscribers shown in expired list was created by Francis Bartucca
Created a menu with Menu Item Type Membership Pro - Members List
Option - Subscription Status - Expired
When I bring up the Members List page on the Front End and sort by Subscription End Date I notice two subscribers at the bottom of the list (about 100 subscribers in list) that are active.
What is different about these two subscribers? These are the only two subscribers who, last year, had upgraded to a different plan while their current plan was active. When they upgraded, their active plan status was changed to expired and their new plan became their current active plan.
As of today, 2023-03-16, their plans show expire date of 2023-12-31. All other subscribers in the expired list show that their plans expired on 2022-12-31.
Frank Bartucca
Asheville Mushroom Club
Option - Subscription Status - Expired
When I bring up the Members List page on the Front End and sort by Subscription End Date I notice two subscribers at the bottom of the list (about 100 subscribers in list) that are active.
What is different about these two subscribers? These are the only two subscribers who, last year, had upgraded to a different plan while their current plan was active. When they upgraded, their active plan status was changed to expired and their new plan became their current active plan.
As of today, 2023-03-16, their plans show expire date of 2023-12-31. All other subscribers in the expired list show that their plans expired on 2022-12-31.
Frank Bartucca
Asheville Mushroom Club
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
2 months 3 weeks ago #157198
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Active subscribers shown in expired list
Hi Francis
That's unfortunately, how it is designed to work. When their subscription for other plan is expired, they are still being expired members for the plan and will still being displayed on that list
For your need, try to edit the menu item, set SQL Command parameter to below SQL code to see if it works
Regards,
Tuan
That's unfortunately, how it is designed to work. When their subscription for other plan is expired, they are still being expired members for the plan and will still being displayed on that list
For your need, try to edit the menu item, set SQL Command parameter to below SQL code to see if it works
tbl.user_id NOT IN (SELECT user_id FROM #__osmembership_subscribers WHERE published = 1)Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Francis Bartucca
- Topic Author
- Away
- New Member
-
Less
More
- Posts: 6
- Thank you received: 0
2 months 3 weeks ago #157200
by Francis Bartucca
Replied by Francis Bartucca on topic Active subscribers shown in expired list
Thanks Tuan,
The SQL filter worked! Excluding records with published = 1 user_id was all that was needed.
Best regards,
Francis
The SQL filter worked! Excluding records with published = 1 user_id was all that was needed.
Best regards,
Francis
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
-
2 months 3 weeks ago #157201
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Active subscribers shown in expired list
Great. Happy to hear that and thanks for the update Francis
Tuan
Tuan
Please Log in or Create an account to join the conversation.