Data Explorer의 ID

tshenry · 4월 20, 2022, 2:52오전

실제로 Discourse UI에서 결과를 더 아름답게 보이게 하는 몇 가지 작은 트릭이 더 있습니다.

이 오래된 파일에는 몇 가지 예시가 있습니다:

github.com/discourse/discourse-data-explorer

test/test_query.sql

9956b9833

SELECT
  (SELECT id FROM badges LIMIT 1) as badge_id,
  (SELECT id FROM categories LIMIT 1) as category_id,
  (SELECT id FROM groups LIMIT 1) as group_id,
  '<h2 class="fa fa-google"> hello</h2>' as html$html,
  (SELECT id FROM posts LIMIT 1) as post_id,
  'hello' as text$text,
  (SELECT id FROM topics LIMIT 1) as topic_id,
  (SELECT id FROM users LIMIT 1) as user_id,
  TIMESTAMP 'yesterday' as reltime$time,
  1 as end

여유가 될 때 주 Data Explorer 토픽에 이 내용을 통합할 예정입니다.

글		댓글	조회수
Adding a direct link to a topic in a data explorer query Data & reporting data-explorer	9	279	8월 28, 2024
Adding Username instead of User ID in a query Data & reporting sql-query	2	640	11월 8, 2023
Allow topic links in reports to be clickable Data & reporting	2	308	7월 1, 2024
Which table holds the post URL? Development	2	551	2월 4, 2021
Searching for the topic/post by ID? Feature	42	8805	8월 9, 2025

Data Explorer의 ID

Related topics