You can filter a userlist based off subscription using the below Advanced Filter usage. These are just some examples and you can extend them however necessary like checking for different statuses or specific date range.
Active
Code:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' ) >= 1 )
Expired
Code:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' ) >= 1 )
This isn't filtered to a specific plan. If you only want to show from a specific plan you'd use the below for example.
Active
Code:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'A' AND sub.`plan_id` = PLAN_ID_HERE ) >= 1 )
Expired
Code:
( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' AND sub.`plan_id` = PLAN_ID_HERE ) >= 1 )
Be sure to replace PLAN_ID_HERE with your actual plan id.
krileon
