# Allow topic links in reports to be clickable

**URL:** https://meta.discourse.org/t/allow-topic-links-in-reports-to-be-clickable/314438
**Category:** Data & reporting
**Created:** [July 1, 2024, 10:58am UTC](https://meta.discourse.org/t/allow-topic-links-in-reports-to-be-clickable/314438 "2024-07-01T10:58:10Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![NateDhaliwal](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/natedhaliwal/32/313494_2.png) [@NateDhaliwal](https://meta.discourse.org/u/NateDhaliwal)
#### Post date: [July 1, 2024, 10:58am UTC](https://meta.discourse.org/t/allow-topic-links-in-reports-to-be-clickable/314438/1 "2024-07-01T10:58:10Z")

</div>

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](https://global.discourse-cdn.com/meta/original/4X/4/3/0/4303e8ba9f08dd743ea99163430ca8e666227824.jpeg)

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [July 1, 2024, 12:07pm UTC](https://meta.discourse.org/t/allow-topic-links-in-reports-to-be-clickable/314438/2 "2024-07-01T12:07:49Z")

</div>

For reports viewed ‘onsite’ you can alias the `id` from the topic (or post, etc) tables and use the [data explorer](https://meta.discourse.org/t/32566?silent=true) magic to turn it into a usable link:

```sql
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:

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

```

Does that help?

---

<div class="post-metadata">

### Author: ![NateDhaliwal](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/natedhaliwal/32/313494_2.png) [@NateDhaliwal](https://meta.discourse.org/u/NateDhaliwal)
#### Post date: [July 1, 2024, 12:56pm UTC](https://meta.discourse.org/t/allow-topic-links-in-reports-to-be-clickable/314438/3 "2024-07-01T12:56:59Z")

</div>

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