We currently have some automated data explorer scripts being sent to senior stakeholders. There is currently one new topic appearing stating “this one doesn’t have a response, someone needs to action this.” They would like a direct link to the topic in question to answer Current data explorer has…

The data explorer has a selection of magic aliases to make the results more interactive. :magic_wand: Formatting Data Explorer Table Results A lot of them work automatically, depending on what table you use. For instance, pulling topic_id from the posts table will make it an interactive link to the…

I think you can create the URL as described in Allow topic links in reports to be clickable - #2 by JammyDodger . If you don’t have the slug, you could just add, for example, “-” as Discourse relies on the topic ID.

Hi @SStrong I guess you could get the links by naming the required columns topic_id or post_id. Here is a screenshot: <a class="lightbox" href="https://global.discourse-cdn.com/meta/original/4X/b/7/0/b70c2fd92e06aa1d494008448056d30592b62fc6.png" data-download-href="/uploads/short-url/q7judEamcEffviNjiDKlfBu7i98.png?dl=1" title="This image shows a computer screen with a user interface that includes various elements such as a text editor, a query plan, and a console output. (Captioned by AI)" rel="noopener nofollow ugc">[This image shows a computer screen with a user interface that includes various elements such as a text editor, a query plan, and a console output. (Captioned by AI)]

Why and how does that work? It does work but I’m a bit confused as to why

Thanks, will read through the extra documentation at a later stage but much appreciated

Ok, so this 100% works just in Data explorer , however… When a user receives an automated email using the Automation plugin, the only way the user can see this functionality is by going directly to the Data explorer report. I.e. these links to the topics don’t come through in the body of the email …

I think for the scheduled data explorer automation you would need to use the second method and build the URL.

Thanks, with a bit of tweaking this worked, thanks (sorry not a dev so a lot of these learnings are new, hence the questions)

That’s okay. :slight_smile: The chances are that if you have questions others will as well, so it all adds to the knowledge pile. :books:

데이터 탐색 쿼리에 주제에 대한 직접 링크 추가

커뮤니티 구축 데이터 및 보고

Lhc_fl (Linca) 8월 22, 2024, 3:53오후 3

안녕하세요 @SStrong

필요한 컬럼을 topic_id 또는 post_id로 명명하면 링크를 가져올 수 있을 것 같습니다. 아래는 스크린샷입니다:

글		댓글	조회수
Allow topic links in reports to be clickable Data & reporting	2	299	7월 1, 2024
Need data explorer query to export an entire topic Data & reporting sql-query	2	539	11월 12, 2023
Report Links to New Topics by Date? Data & reporting	1	980	4월 13, 2020
Challenges with automating Data Explorer results Feature data-explorer , automation	3	193	9월 17, 2025
Exporting all Topic titles and IDs? Development	1	1609	1월 22, 2018

데이터 탐색 쿼리에 주제에 대한 직접 링크 추가

Related topics