允许在报告中点击主题链接

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?

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 个赞

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

1 个赞