我如何查看调查结果或回应

支持
1

大家好：
我在这里添加了一个用于创建调查的插件 https://github.com/discourse/discourse-surveys/。

有人能帮我看看如何查看此调查的回复或结果吗？这已经在 Surveys Plugin documentation? - #6 by Nick_Chomey 这里讨论过。这个功能添加了吗？

提前感谢！

4

目前，调查插件没有后端用户体验来查看调查结果。为此，我们依赖于 Data Explorer 查询。示例：

-- [params]
-- text :survey_name = survey

SELECT s.id, 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 = :survey_name
ORDER BY s.id DESC
5 个赞
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.