Skip to Content Skip to Menu

list of the members

  • HdCms
  • HdCms
  • OFFLINE
  • Posts: 51
  • Thanks: 2
  • Karma: 0
9 years 5 months ago - 9 years 5 months ago #265219 by HdCms
Replied by HdCms on topic [SOLVED] list of the members
Hi,
We do not understand. I think.
A picture is better

Regards
Attachments:
Last edit: 9 years 5 months ago by nant.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #265220 by krileon
Replied by krileon on topic list of the members
You don't need to use a filter for your userlist to only show users in a specific usergroup. That's done on the Global tab with the Usergroups parameter.

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.

  • HdCms
  • HdCms
  • OFFLINE
  • Posts: 51
  • Thanks: 2
  • Karma: 0
9 years 5 months ago #265228 by HdCms
Replied by HdCms on topic list of the members
Hi,
I am a member of Group A -> I lists the members of group A
I am a member of group A and B -> I lists the members of group A and B

BUT I have 100 groups, and I would not want to do 100 user lists
I would like to make a list that automatically adapts to the groups of which I am a member. For this, the only solution is a sql query that will look for joomla ACL groups (or I am registered)

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48477
  • Thanks: 8281
  • Karma: 1443
9 years 5 months ago #265255 by krileon
Replied by krileon on topic list of the members
You'll need to use the "g" alias (that's the alias for the _user_usergroup_map join) with a subquery to filter the groups down to those you're in. The below will probably work.

Code:
g.`group_id` IN ( SELECT `group_id` FROM `#__user_usergroup_map` WHERE `user_id` = '[user_id]' )

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.
The following user(s) said Thank You: HdCms

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

  • HdCms
  • HdCms
  • OFFLINE
  • Posts: 51
  • Thanks: 2
  • Karma: 0
9 years 5 months ago - 9 years 5 months ago #265285 by HdCms
Replied by HdCms on topic list of the members
GREAT it works :)
thank you
Last edit: 9 years 5 months ago by HdCms.
The following user(s) said Thank You: nant, krileon

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

Moderators: beat, nant, krileon
Powered by Kunena Forum