We would like to welcome users when they achieve trust level 3. (We would monitor this periodically through a Data Explorer query.) Does the database contain information on when a user’s trust level changes? Or only what the user’s current trust level is? Thanks, Randy

[תמונה] Randy_Hulett: Does the database contain information on when a user’s trust level changes? Yes, the group_users created_at field can be used for that. It will be set to the date when the user was added to the group. You could try running a query like the one below at periodic intervals to find all users who were added to the group during the interval. The query’s granted_at field expects a date in the form yyyy-mm-dd. For example 2020-09-15 --[params] -- string :group_name = trust_level_3 -- date :granted_at SELECT user_id, gu.created_at::date FROM group_users gu JOIN groups g ON g.id = gu.group_id WHERE gu.created_at::date >= :granted_at AND g.name = :group_name If you need more user details, it would be possible to update the query to join the users table, or the user_emails table.

[תמונה] Randy Hulett: We would like to welcome users when they achieve trust level 3. (We would monitor this periodically through a Data Explorer query.) Hi @Randy_Hulett , is this query available somewhere? I am looking to monitor users that achieve TLs 2 and 3 but don’t seem to find the query for that.

If you join on the groups and group_users tables as @simon showed, you can add something like this to your WHERE clause: WHERE gu.created_at::date >= :since AND g.name = 'trust_level_3' AND u.admin = false

שאילתה ב-Data Explorer לזיהוי תאריכי שינוי ברמת אמון

קהילה נתונים ודיווח

Randy_Hulett (Randy Hulett) 15 בספטמבר,‏ 2020,‏ 8:55pm 3

This works perfectly, @simon.
Thanks so much!!!

נושא		תגובות	צפיות
Dashboard Report - Trust Level Growth Data & reporting sql-query , dashboard-reports , dashboard-sql	0	349	6 בפברואר,‏ 2024
Report(s) of users trust level promotions? Product Support	0	375	1 באוגוסט,‏ 2021
List of users with locked trust level due to group membership? Data & reporting sql-query	17	2897	30 באפריל,‏ 2023
Public-facing date for when a user progressed past TL0 Feature	1	979	30 באוגוסט,‏ 2017
Statistics per group and per trust level? Product Support	6	1383	25 באוקטובר,‏ 2022

שאילתה ב-Data Explorer לזיהוי תאריכי שינוי ברמת אמון

נושאים קשורים