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

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: [badge options]

[תמונה] 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

תג לקריאת נושא?

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

barto_95 (🇵🇹 | ) 9 באוקטובר,‏ 2023,‏ 9:21am 5

Ok thank’s no error now

what do you recommend as a trigger ?

נושא		תגובות	צפיות
Badge for reading a page? Data & reporting sql-triggered-badge	0	290	8 בדצמבר,‏ 2023
Grant Custom Badge Upon Reading ToS Data & reporting sql-triggered-badge	7	375	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	3 במרץ,‏ 2015
Badges for reading [ :warning: intensive] Data & reporting sql-triggered-badge	5	371	7 באוגוסט,‏ 2015
A badge for reading time? Data & reporting sql-triggered-badge	2	705	5 בפברואר,‏ 2021

תג לקריאת נושא?

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