# Badge for reading a topic?
**URL:** https://meta.discourse.org/t/badge-for-reading-a-topic/281534
**Category:** Data & reporting
**Tags:** sql-triggered-badge
**Created:** [October 8, 2023, 1:23pm UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534 "2023-10-08T13:23:15Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@barto\_95](https://meta.discourse.org/u/barto_95)
#### Post date: [October 8, 2023, 1:23pm UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/1 "2023-10-08T13:23:15Z")
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 ?
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [October 8, 2023, 8:09pm UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/2 "2023-10-08T20:09:11Z")
I think this should be possible with something like:
```sql
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
```
---
### Author:  [@barto\_95](https://meta.discourse.org/u/barto_95)
#### Post date: [October 9, 2023, 8:49am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/3 "2023-10-09T08:49:41Z")
I test and received this error:
`Error : Contract violation: Query targets posts, but does not return a 'post_id' column`
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [October 9, 2023, 8:57am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/4 "2023-10-09T08:57:45Z")
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:
---
### Author:  [@barto\_95](https://meta.discourse.org/u/barto_95)
#### Post date: [October 9, 2023, 9:21am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/5 "2023-10-09T09:21:30Z")
> [@JammyDodger](#):
>
> ```plaintext
> 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 ?
---
### Author:  [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [October 9, 2023, 9:58am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/6 "2023-10-09T09:58:19Z")
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.
---
### Author:  [@barto\_95](https://meta.discourse.org/u/barto_95)
#### Post date: [October 9, 2023, 10:01am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/7 "2023-10-09T10:01:01Z")
Ok I configured this first for test
this happens every 22 hours it seems to me regarding the assignment of badges
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [November 8, 2023, 10:01am UTC](https://meta.discourse.org/t/badge-for-reading-a-topic/281534/8 "2023-11-08T10:01:17Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.