Skip to Content Skip to Menu

🎃 Happy Halloween! Treat yourself with an awesome discount on memberships! Get 20% off now with code SPOOKY-2024!

Filtering by users privacy settings

  • TeeWee
  • TeeWee
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
8 years 2 months ago #284287 by TeeWee
Filtering by users privacy settings was created by TeeWee
Hi,

is it possible to filter the userlist by users privacy settings
(only show user when set to public)

Where are privacy settings stored? After importing 800 Users, i want to set their default privacy setting as "private"

Thanks and regards
Thomas

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48459
  • Thanks: 8280
  • Karma: 1443
8 years 2 months ago #284294 by krileon
Replied by krileon on topic Filtering by users privacy settings
Privacy settings already affect the userlist so if the user doesn't have access to that users profile via profile privacy or they search a field that is private for example then that user won't be displayed. Regardless yes it's possible to filter a userlist by privacy setting using a subquery in the Advanced Filter usage.

The private value for profile privacy is 99. So the below should exclude all users with profile privacy set to 99.

Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_plugin_privacy` AS p WHERE p.`type` = 'profile' AND ( p.`subtype` = '' OR p.`subtype` IS NULL ) AND p.`user_id` = u.`id` AND `rule` = 99 ) = 0 )

The below should only display users if profile privacy is set to public.

Code:
( ( SELECT COUNT(*) FROM `#__comprofiler_plugin_privacy` AS p WHERE p.`type` = 'profile' AND ( p.`subtype` = '' OR p.`subtype` IS NULL ) AND p.`user_id` = u.`id` AND `rule` = 0 ) > 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 or Create an account to join the conversation.

  • TeeWee
  • TeeWee
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
8 years 2 months ago #284313 by TeeWee
Replied by TeeWee on topic Filtering by users privacy settings
Thank you


Regards
Thomas

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

Moderators: beatnantkrileon
Powered by Kunena Forum