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

[image] 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.

[image] 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 query to identify trust level change dates

Community Building Data & reporting

Randy_Hulett (Randy Hulett) September 15, 2020, 8:55pm 3

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

Topic		Replies	Views
Dashboard Report - Trust Level Growth Data & reporting sql-query , dashboard-reports , dashboard-sql	0	349	February 6, 2024
Report(s) of users trust level promotions? Product Support	0	375	August 1, 2021
List of users with locked trust level due to group membership? Data & reporting sql-query	17	2896	April 30, 2023
Public-facing date for when a user progressed past TL0 Feature	1	977	August 30, 2017
Statistics per group and per trust level? Product Support	6	1381	October 25, 2022

Data Explorer query to identify trust level change dates

Related topics