Skip to Content Skip to Menu

[SOLVED] GJ2.5 userlist of a group?

  • jojo12
  • jojo12
  • OFFLINE
  • Posts: 957
  • Thanks: 109
  • Karma: 25
12 years 7 months ago - 12 years 7 months ago #194306 by jojo12
[SOLVED] GJ2.5 userlist of a group? was created by jojo12
Hi,
is there a possibility to create a userlist of a groupjive group? Or in the backend or frontend. Would be good. But I've no idea how to create. (I think cb userlist and gj are not combinated?)
Last edit: 12 years 7 months ago by krileon.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48479
  • Thanks: 8283
  • Karma: 1443
12 years 7 months ago - 12 years 7 months ago #194347 by krileon
Replied by krileon on topic Re: GJ2.5 userlist of a group?
You could add an Advanced filter to a CB Userlist to filter out those that don't belong to a specific group. Example as follows.
Code:
( ( SELECT COUNT(*) FROM `#__groupjive_users` AS gj WHERE gj.`group` = 'GROUP ID HERE' AND gj.`user_id` = u.`id` AND gj.`status` IN ( 1, 2, 3, 4 ) ) > 0 )

With the above replace GROUP ID HERE with the id of the group you want to filter by. If you want to get all users that belong to at least 1 group then you could use the below.
Code:
( ( SELECT COUNT(*) FROM `#__groupjive_users` AS gj WHERE gj.`user_id` = u.`id` AND gj.`status` IN ( 1, 2, 3, 4 ) ) > 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.
Last edit: 12 years 7 months ago by krileon.
The following user(s) said Thank You: jojo12, pepperstreet

Please Log in or Create an account to join the conversation.

  • jojo12
  • jojo12
  • OFFLINE
  • Posts: 957
  • Thanks: 109
  • Karma: 25
12 years 7 months ago #194399 by jojo12
Replied by jojo12 on topic Re: GJ2.5 userlist of a group?
Hi,
I tried your first proposal, inserted the group id... but I got an error:
Diese Seite:
Warning: Invalid argument supplied for foreach() in /srv/www/vhosts/mysite.ch/httpdocs/administrator/components/com_comprofiler/library/cb/cb.lists.php on line 347
Fehler in der Datenbank-Abfrage. Der Administrator dieser Seite kann die Debug-Einstellungen aktivieren, um die Abfrage zu sehen und zu korrigieren.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48479
  • Thanks: 8283
  • Karma: 1443
12 years 7 months ago #194402 by krileon
Replied by krileon on topic Re: GJ2.5 userlist of a group?
Whoops, above queries fixed; missed FROM. :blush:

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 or Create an account to join the conversation.

  • jojo12
  • jojo12
  • OFFLINE
  • Posts: 957
  • Thanks: 109
  • Karma: 25
12 years 7 months ago - 12 years 7 months ago #194427 by jojo12
Replied by jojo12 on topic Re: GJ2.5 userlist of a group?
I don't know, nothing changed!
Warning: Invalid argument supplied for foreach() in /srv/www/vhosts/mysite.ch/httpdocs/administrator/components/com_comprofiler/library/cb/cb.lists.php on line 347
Fehler in der Datenbank-Abfrage. Der Administrator dieser Seite kann die Debug-Einstellungen aktivieren, um die Abfrage zu sehen und zu korrigieren.

I have to change something in this formula? Input the group id I know.
I mean: no spaces or something like that?
Last edit: 12 years 7 months ago by jojo12.

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48479
  • Thanks: 8283
  • Karma: 1443
12 years 7 months ago #194429 by krileon
Replied by krileon on topic Re: GJ2.5 userlist of a group?
Don't know what to tell you, I edited my previous posts fixing the bug in the queries; you need to re-copy them and supply the group id then save your userlist and refresh the page to see if it's working. I tested both the above usages as working. That error sounds familiar, but was pretty sure it was fixed with CB 1.8 stable. PM backend super administrator login credentials and will take a look.

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 or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum