List of users, membership-status

I'm using CBsubs to control memberships, but in the list of users (Community Builder->User Management) all users are listed with a membership, even when the membership has expired. Is this correct?
How can I see how many users that have a valid membership?

eirikop wrote: I'm using CBsubs to control memberships, but in the list of users (Community Builder->User Management) all users are listed with a membership, even when the membership has expired. Is this correct?
How can I see how many users that have a valid membership?

Unless the user list is filtering based on some CB Field that is populated/reset upon subscription / ending of subscription, then the userlist is correct.

You would need to use the CBSubs CB Fields integration plugin to assign a value to a CB field upon plan subscription and remove value when subscription ends.

Then you would need to filter your userlist and show only users that have the field set.

You can also use the CB User Manager in backend that can automatically filter against CBSubs plans and their status.

If you want to filter out cb subs expired users, create an advanced filter and add..

( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` WHERE `user_id` = u.`id` AND `status` = 'A' AND `plan_id` = '1' ) >= 1 )

Where would one put this filter? My guess is somewhere in the sql actions plugin integration, but where and how exactly?

Another idea, in Access tab of a plan there is a setting that can change a users access level... can or does this get changed to something else when the subscription ends?