Grant Badge when user visits link

[JammyDodger]

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

@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