Hi, Any advice on how can I remove certain groups from this query? SELECT sum(p.score) / count(p) as "average score per post", count(p.id) as post_count, p.user_id FROM posts p JOIN users u ON u.id = p.user_id WHERE p.created_at >= CURRENT_DATE - INTERVAL '3 month' AND u.active GR…

I didn’t really test this. -- [params] -- int_list :exclude_groups = 12, 2, 3 SELECT sum(p.score) / count(p) as "average score per post", count(p.id) as post_count, p.user_id FROM posts p JOIN users u ON u.id = p.user_id LEFT JOIN group_users gu on u.id = gu.user_id WHERE p.created_…

Thank you @pfaffman . That’s very kind of you. I ran the script and I see members of the excluded groups appearing in the results. Of course, they are members of many groups. Is there a way for this script to absolutely exclude all members of all groups in the :exclude_groups list? Thank you for yo…

Oh. Right. The not in didn’t work as I’d first thought. It mostly does nothing. I think what needs to happen is first a query that gets users not in any groups and then to join that with the other part of the query. Sorry.

-- [params] -- int_list :exclude_groups = 1,2 SELECT sum(p.score) / count(p) as "average score per post", count(p.id) as post_count, p.user_id FROM posts p JOIN users u ON u.id = p.user_id WHERE p.created_at >= CURRENT_DATE - INTERVAL '3 month' …

@RGJ , Your contributions to the Discourse ecosystem and your amazing support for me as a customer are truly appreciated. I am thrilled that you provide such an incredible hosting service!

استبعاد المجموعات من استعلام الأعضاء الأعلى جودة

مجتمع البيانات والتقارير

outofthebox (Carson) 20 يوليو 2020، 2:43م 6

@RGJ،

إن مساهماتك في نظام Discourse البيئي ودعمك المذهل لي كعميل تُقدّر حقًا. أنا متحمس جدًا لأنك توفر خدمة استضافة مذهلة!

الموضوع		الردود	مرات العرض
How to filter out a group? Data & reporting sql-query	2	215	14 مايو 2018
How to count likes_received excluding a specific group Data & reporting sql-query	0	371	14 أبريل 2022
Users In Specific Group(s) BUT NOT In Other Group(s) Data & reporting sql-query	0	164	14 مايو 2019
How can I count posts in last month by a specific group of users? Data & reporting sql-query	4	1935	9 نوفمبر 2016
Advanced search filters: posts by group Product Support search	9	1156	1 فبراير 2023

استبعاد المجموعات من استعلام الأعضاء الأعلى جودة

الموضوعات ذات الصلة