CB List of active members only

How can I create a list using List Management that shows only active members? There is no filtering by 'Status'.

How about creating a list on non-active members only? I'm aware of the filtering in the 'Subscriptions' section but I need one-click pre-filtered report.

Are you meaning a filter within a userlist or filtering from backend user management? If needing an Online users and/or Offline users filter for frontend userlists please see the below thread.

www.joomlapolis.com/forum/154-advanced-members-support/159082-possible-for-search-to-list-online-users-first#159144

Regarding filtering backend user management simply select from the filter drop-down "- Select Login State -" as "Logged In". This would display only those users logged in.

What I mean is creating some kind of report. e.g. Members List, that is linked to a menu item.

So far I already created a list using List Management and created a menu (type is Community Builder : Users List). However, I'm not sure if all members will be shown in the list instead of just active members.

Besides this, I also need to create a report of expired members, etc that is accessible from the frontend. Is there any other Joomla extension that can work with CB/CBSubs?

So far I already created a list using List Management and created a menu (type is Community Builder : Users List). However, I'm not sure if all members will be shown in the list instead of just active members.

I don't understand what you mean by active members. Users of a certain CBSubs subscription? Users that are currently logged in? Please provide further details.

Besides this, I also need to create a report of expired members, etc that is accessible from the frontend. Is there any other Joomla extension that can work with CB/CBSubs?

This can be done using a userlist and an advanced filter to query the database and check if the user has an expired subscription or not. You'd then just limit the list to administrators only or whatever the case. I'm not aware of what all can and can not interact with CBSubs, but only those that are querying the database as the API is not yet available.

krileon wrote: I don't understand what you mean by active members. Users of a certain CBSubs subscription? Users that are currently logged in? Please provide further details.

Active means subscription is still valid (not expired/blocked).

This can be done using a userlist and an advanced filter to query the database and check if the user has an expired subscription or not. You'd then just limit the list to administrators only or whatever the case. I'm not aware of what all can and can not interact with CBSubs, but only those that are querying the database as the API is not yet available.

Advanced filter is basically the 'WHERE' clause of the SQL, right? How can I filter by CBSubs field since subscription status is not one of [cb_fieldname] field?

Active means subscription is still valid (not expired/blocked).

I see, thank you for clarification.

Advanced filter is basically the 'WHERE' clause of the SQL, right? How can I filter by CBSubs field since subscription status is not one of [cb_fieldname] field?

Using the below Advanced filter you can filter users based off plan activity. You'll need to provide the plan id of the plan you want to filter by.

Please replace PLAN_ID with the actual id of the plan you want to filter by. Additionally if you want to filter by multiple plans you can use the below.