IDs in Data Explorer

tshenry · April 20, 2022, 2:52am

There are actually quite a few other little tricks to beautifying your results in the Discourse UI.

This old file shows some examples:

discourse/discourse-data-explorer/blob/9956b9833e223a0b459acc89056cc7546368241d/test/test_query.sql

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

I’ll integrate this into the main Data Explorer topic at some point when I have a spare moment.

Topic		Replies	Views
Formatting Data Explorer Table Results Data & reporting data-explorer , sql-tutorial	0	669	September 5, 2023
Adding Username instead of User ID in a query Data & reporting sql-query	3	477	November 8, 2023
A summary of votes by topic, including tags Data & reporting topic-voting , sql-query	5	346	January 31, 2023
Data Explorer Tutorial - Part 1 - Writing Your First Query Data & reporting data-explorer , sql-tutorial	0	1100	September 5, 2023
Find Links in Topics Data & reporting sql-query	0	150	May 7, 2024

IDs in Data Explorer

Related topics