How can I automatically grant a badge when the user visits a link within the discourse forum? ex: https://myforum.example.com?special_access=true

I think there should be, but that would be a different query. :slight_smile: This one awards a badge for clicking on a specific link in a specific forum post. If you want to award a badge for a user visiting a particular topic I think it would be: SELECT DISTINCT tv.user_id, MIN(tv.viewed_at) granted_at FROM topic_views tv WHERE tv.topic_id = 728 GROUP BY tv.user_id (Replacing ‘728’ with the relevant topic_id)

If it’s a specific link shared in a specific post, I think this one would do it: SELECT DISTINCT tlc.user_id, MIN(tlc.created_at) granted_at FROM badge_posts p LEFT JOIN topic_links tl ON tl.post_id = p.id LEFT JOIN topic_link_clicks tlc ON tlc.topic_link_id = tl.id WHERE tl.post_id = 1246 AND tl.url = 'https://meta.discourse.org/' AND tlc.user_id IS NOT NULL GROUP BY tlc.user_id You’d need to grab the post_id of your specific post from its post json (or run a look up through the data explorer) [clicky clicky]

I think this could work. I only want to grant this badge to members of our course. Is there any way to hide a topic from the general public and only make it available to those who click on it via a link. Secondly, how can this be done using Dfata explorer plugin? [image] JammyDodger: You’d need to grab the post_id of your specific post from its post json (or run a look up through the data explorer)

[image] Sami Syed: I only want to grant this badge to members of our course. Is there any way to hide a topic from the general public and only make it available to those who click on it via a link. I’m not 100% sure I’m following the method you’re using for this? You may want to have a check that you’re not overcomplicating the setup. [image] Sami Syed: Secondly, how can this be done using Dfata explorer plugin? If checking the json isn’t your cup of tea, then a post_id lookup query would be something like this: -- [params] -- topic_id :topic_id -- int :post_number SELECT id FROM posts WHERE topic_id = :topic_id AND post_number = :post_number Then you can use the URL of the post to pull out the topic id and post number to enter into the parameter boxes. eg: https://meta.discourse.org/t/grant-badge-when-user-visits-link/276700/4 (worth noting that the OP is always post_number 1, even if it’s not in the topic link) Actually, there’s a magic parameter that might make looking up a post_id using the data explorer even easier… -- [params] -- post_id :url SELECT id FROM posts WHERE id = :url Paste the relevant URL for the post into the parameter box, et voila - it pops out the post_id :slight_smile: [post_id]

[image] JammyDodger: -- [params] -- post_id :url SELECT id FROM posts WHERE id = :url I just tried this but ti won’t output any ID. It’s just blank: [Screenshot 2023-08-28 121948]

The red background makes me think it’s not a full post URL. If it’s a topic URL you need to pop a /1 on the end: https://meta.discourse.org/t/grant-badge-when-user-visits-link/276700/1

[image] JammyDodger: AND tl.url = 'https://meta.discourse.org/' Im assuming this needs to be replaced with the post URL including the ‘/1’?

That bit needs to be replaced with the link they’re clicking on within the post. And the post_id is the post in which the link is pasted/shared.

Oh I see, so there is no way to just grant the badge just by them visiting the post link?

Grant Badge when user visits link

Community Building Data & reporting

JammyDodger August 26, 2023, 4:58am 3

How about using the topic_link_clicks table?

I think I might have a manual badge that could benefit from this. I’ll have a think.

Topic		Replies	Views
Custom badge query is not targeting posts Product Support	1	819	January 2, 2019
Grant Custom Badge Upon Reading ToS Data & reporting sql-triggered-badge	7	374	May 31, 2025
How to see that a Topic has earned a badge Feature	5	1755	July 27, 2015
Badge based on link stats? Data & reporting sql-query	5	1348	August 27, 2015
Linking badge sql to a topic id? Product Support sql-triggered-badge	3	184	June 11, 2026

Grant Badge when user visits link

Related topics