I’m using this Discourse Surveys plugin: GitHub - discourse/discourse-surveys · GitHub Upon submitting surveys, I see that radio buttons, checkboxes, and dropdowns seem to register as NULL in the database. It also seems to have registered one answer twice: [slack_An2SO2hJ06]

The value for [image] Jordan Violet: radio buttons, checkboxes, and dropdowns are stored in a separate table. This should get you were you need to be :slight_smile: -- [params] -- null int :user_id -- string :name SELECT s.name, s.post_id, sf.question, COALESCE(sr.value, sfo.html) AS value, sr.user_id, sr.created_at as responded_at FROM surveys s JOIN survey_fields sf ON sf.survey_id = s.id JOIN survey_responses sr ON sr.survey_field_id = sf.id LEFT JOIN survey_field_options sfo ON sfo.id = sr.survey_field_option_id WHERE s.name = :name AND (:user_id IS NULL OR sr.user_id = :user_id) ORDER BY sr.user_id I have added a per user query option (when left empty it queries all user per survey), but feel free to drop AND (:user_id IS NULL OR sr.user_id = :user_id) if you are not interested in that.

Querying Survey fields and responses

Community Building Data & reporting

jordan-violet (Jordan Violet) May 15, 2024, 6:46pm 3

Ah, I didn’t even catch that extra table! Thank you!

Topic		Replies	Views
How can I see Survey Results or Responses Product Support surveys	1	892	September 20, 2022
Discourse Surveys Plugin official , experimental , surveys	16	3725	September 3, 2026
Surveys Plugin documentation? Product Support surveys	11	2543	November 17, 2021
Free form field for Polls Feature polls	1	1262	August 24, 2015
Query to filter users by sign-up 'custom fields' Data & reporting sql-query , user-custom-fields	11	1869	January 17, 2022

Querying Survey fields and responses

Related topics