Allow topic links in reports to be clickable

Data & reporting
1

In a report that I ran, I realised that it showed all the topic ids, as well as the topic links, but the link wasn’t clickable; it was just normal text. Is there a way to make it clickable?

Screenshot_20240701_185429_Chrome
Screenshot_20240701_185429_Chrome846×362 59.7 KB

2

For reports viewed ‘onsite’ you can alias the id from the topic (or post, etc) tables and use the data explorer magic to turn it into a usable link:

SELECT 
    id AS topic_id
FROM topics

You can also construct an URL and alias it as SOMETHING_url to turn it into a hyperlink. eg:

SELECT 
  'https://meta.discourse.org/t/' || slug || '/' || id AS topic_url
FROM topics

Does that help?

2 Likes
3

Understood. I’ll pass it along to the admins.

1 Like