CB List of active members only
- apdt
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 3
12 years 11 months ago #164976
by apdt
CB List of active members only was created by apdt
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.
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.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
12 years 11 months ago #165015
by krileon
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.
Replied by krileon on topic Re: CB List of active members only
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.
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.
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.
Please Log in to join the conversation.
- apdt
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 3
12 years 11 months ago #165024
by apdt
Replied by apdt on topic Re: CB List of active members only
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.
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?
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
12 years 11 months ago #165035
by krileon
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.
Replied by krileon on topic Re: CB List of active members only
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.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.
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.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?
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.
Please Log in to join the conversation.
- apdt
- OFFLINE
-
Premium Member
- Posts: 104
- Thanks: 2
- Karma: 3
12 years 11 months ago #165071
by apdt
Replied by apdt on topic Re: CB List of active members only
Active means subscription is still valid (not expired/blocked).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.
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?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.
Please Log in to join the conversation.
- krileon
- Team Member
- OFFLINE
- Posts: 68602
- Thanks: 9108
- Karma: 1434
12 years 11 months ago #165104
by krileon
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.
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.
Replied by krileon on topic Re: CB List of active members only
I see, thank you for clarification.Active means subscription is still valid (not expired/blocked).
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.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?
( ( SELECT subs.`id` FROM `#__cbsubs_subscriptions` subs WHERE subs.`user_id` = ue.`id` AND `plan_id` = PLAN_ID AND `status` = 'A' ) > 0 )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.
( ( SELECT subs.`id` FROM `#__cbsubs_subscriptions` subs WHERE subs.`user_id` = ue.`id` AND `plan_id` IN ( PLAN_ID1, PLAN_ID2, PLAN_ID3 ) AND `status` = 'A' ) > 0 )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.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.185 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- CB List of active members only