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 sql-tutorial	0	478	September 5, 2023
Adding Username instead of User ID in a query data & reporting sql-query	3	385	November 8, 2023
A summary of votes by topic, including tags data & reporting topic-voting , sql-query	5	285	January 31, 2023
Data Explorer Tutorial - Part 1 - Writing Your First Query data & reporting tutorial , sql-tutorial	0	741	September 5, 2023
What's the 'featured users' feature? support	7	408	March 30, 2022

IDs in Data Explorer

Related Topics