I want to have my list of “Users_Who_Replied_To_A_Topic” Include the user’s NAME. I tried to follow a convention from another thread, which makes these Data Explorer queries include additional information but it didn’t work when I applied the same syntax. Here’s the query I’m running right now, which only returns they “username” of those who replied to a topic… -- https://meta.discourse.org/t/68756/8?u=sidv -- [params] -- topic_id :topic_id = 536 SELECT u.username FROM badge_posts p JOIN topics t ON p.topic_id = t.id JOIN users u ON p.user_id = u.id WHERE t.id = :topic_id GROUP BY p.user_id,u.username

Add , u.name After u.username in the first line.

Thanks for the quick help on this, Jay! I updated to the following, per your suggestion: SELECT u.username, u.name FROM badge_posts p JOIN topics t ON p.topic_id = t.id JOIN users u ON p.user_id = u.id WHERE t.id = :topic_id GROUP BY p.user_id,u.username … then got this error… PG::GroupingError: ERROR: column "u.name" must appear in the GROUP BY clause or be used in an aggregate function LINE 12: SELECT u.username, u.name So I changed the query to the following and it worked like a charm! :tada: SELECT u.username, u.name FROM badge_posts p JOIN topics t ON p.topic_id = t.id JOIN users u ON p.user_id = u.id WHERE t.id = :topic_id GROUP BY p.user_id,u.username,u.name So from my original snippet, I added the following: To the “SELECT” line: , u.name To the “GROUP BY” line: ,u.name Thanks again, @pfaffman for helping me with this syntax!

:squinting_face_with_tongue: Yes indeed! Thanks again :wink:

Data Explorer Query - add additional parameter in export

Community Building Data & reporting

pfaffman (Jay Pfaffman) May 19, 2020, 3:28pm 4

That PhD in education is finally paying off!

Nice work!

Topic		Replies	Views
Export a list of people who replied to a specific topic Data & reporting sql-query	7	1805	August 25, 2017
Adding Username instead of User ID in a query Data & reporting sql-query	2	667	November 8, 2023
Attempting to create Monthly Leaderboard query - head exploding Data & reporting sql-query	18	2056	October 8, 2018
Badge query working in explorer but not in badge SQL? Data & reporting sql-triggered-badge	2	255	August 17, 2022
Displaying user custom fields in data explorer query results Data & reporting sql-query	5	1724	March 15, 2020

Data Explorer Query - add additional parameter in export

Related topics