Badge for reading a topic?

[barto_95]

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 ?

[JammyDodger]

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

[barto_95]

I test and received this error:

Error : Contract violation: Query targets posts, but does not return a 'post_id' column

[JammyDodger]

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:

[barto_95]

@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 ?

[JammyDodger]

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.

[barto_95]

Ok I configured this first for test

this happens every 22 hours it seems to me regarding the assignment of badges