It’s possible to add a badge if user read the specific topic/subject of forum ? and not just opened the topic but he read ~5minutes to be sure the user read the info ?

I think this should be possible with something like: SELECT user_id, CURRENT_TIMESTAMP AS granted_at FROM topic_users WHERE topic_id = 281534 AND total_msecs_viewed/60000 >= 5 -- min number of minutes viewed

I test and received this error: Error : Contract violation: Query targets posts, but does not return a 'post_id' column

[image] JammyDodger: SELECT user_id, CURRENT_TIMESTAMP AS granted_at FROM topic_users WHERE topic_id = 281534 AND total_msecs_viewed/60000 >= 5 -- min number of minutes viewed Ok thank’s no error now what do you recommend as a trigger ?

I think it would have to be Update Daily. I don’t think any of the other triggers would catch a change in the topic_users read time stat.

Ok I configured this first for test this happens every 22 hours it seems to me regarding the assignment of badges

Badge for reading a topic?

Community Building Data & reporting

JammyDodger October 9, 2023, 8:57am 4

I think that’s because you’ve ticked the ‘Query targets posts’ box. If you set it up to more like this it should work fine:

Topic		Replies	Views
Badge for reading a page? Data & reporting sql-triggered-badge	0	290	December 8, 2023
Grant Custom Badge Upon Reading ToS Data & reporting sql-triggered-badge	7	374	May 31, 2025
Badge granted to our staff members that have read the guidelines placed in our hidden staff category Data & reporting sql-triggered-badge	11	368	March 3, 2015
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	371	August 7, 2015
A badge for reading time? Data & reporting sql-triggered-badge	2	704	February 5, 2021

Badge for reading a topic?

Related topics