CB Subs Data to create a CB List

Is there a way to use the status field in cbsubs to create a list on the frontend based upon a status field value ? I would like to make available to my membership managers a list on the front end to be able to go in and mark offline payments as paid..

It's possible to filter the userlist to users who are actively subscribed or expired using Advanced filters. Examples as follows.

www.joomlapolis.com/forum/149-usage/239397-cb-list#305820

To filter based off pending payments for offline payments usage is similar using Advanced filters, but you'd need to check for baskets. Something like the below might work.


That should display every user with a pending basket. If you want it to be specific to your offline payment gateway you'll need to extend the query to filter by the payment gateway id as found in CBSubs > Gateways. Example as follows.


Replace GATEWAY_ID_HERE with the actual id of your payment gateway.

The query works but how do you add column names to the list ? It would be helpful to have at least username but it doesn't appear in the columns list as an option.

You can only select fields for display on a userlist that are already set to display on profile. If you don't want them actually displayed on profile be sure to move them to a tab that is in a not shown on profile position.

i have added the filter query to a cblist that displayed just username and a send email link. after applying the filter it correctly filters down to those members with a pending payment. But I only get 1 record returned even though there are more pending. Is that because of the Count option which would return only one record ?

It's not going to display the same user multiple times. It's a userlist and not a basket list. For that I guess you could try using CB Query Field and querying for how many pending baskets they have then set that field to display on your userlist, but you'll need to make the SQL for that against the _cbsubs_payment_baskets database table.