Hello,
I am unable to filter the CB User Management screen using the CBsubs plan "Subscription expiry date" filter. I am able to filter users by plans with status "expired" (and get a number of results) but when I put a date in either the "Expiry Date is After" or "Expiry Date is Before" fields, the filter then produces a result set of zero (my purpose of doing this is to manually send a custom "please renew" mass email message to those whose specific plan had recently expired).
Here is the CB User Management page with filters applied (and result set of zero):
Here is a sample CBsubs Subscription record of a user I believe should have shown up in my expiry date filtered User Management list:
Versions:
Community Builder: pkg_communitybuilder_2.0.11.ci.2015.10.06.00.20
CBsubs: CBSubs-4.0.1.ci.2015.10.10.00.20
Joomla: 3.4.4
Was able to confirm your issue. It's due to the filter having the wrong operator causing the query to use "=" instead of ">=" and "<=" as needed. The below quickfix should solve your issue.
IN: components/com_comprofiler/plugin/user/plug_cbpaidsubscriptions/xml/views/view.com_comprofiler.showusers.xml
ON: Line 72
FROM:
Kyle (Krileon) Community Builder Team Member Before posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forums CB links:
Documentation
-
Localization
-
CB Quickstart
-
CB Paid Subscriptions
-
Add-Ons
-
Forge
-- If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
-- If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
-- Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
-- My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Thank you both for your quick work. I did not have a chance to apply the quickfix but did apply the nightly build CBSubs-4.0.1.ci.2015.10.14.00.20 and can now successfully filter expired subscriptions by custom date on the CB User Management page. Thanks again.
The following user(s) said Thank You: nant, krileon
krileon
