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

**URL:** <https://meta.discourse.org/t/how-can-i-see-survey-results-or-responses/239403>\
**Category:** Support\
**Tags:** surveys\
**Created:** [2022年九月19日 12:45 UTC](https://meta.discourse.org/t/how-can-i-see-survey-results-or-responses/239403 "2022-09-19T12:45:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pandiyan](https://avatars.discourse-cdn.com/v4/letter/p/3ec8ea/32.png) [@Pandiyan](https://meta.discourse.org/u/Pandiyan)\
**Post date:** [2022年九月19日 12:45 UTC](https://meta.discourse.org/t/how-can-i-see-survey-results-or-responses/239403/1 "2022-09-19T12:45:52Z")

</div>

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

有人能帮我看看如何查看此调查的回复或结果吗？这已经在 [Surveys Plugin documentation? - #6 by Nick\_Chomey](https://meta.discourse.org/t/surveys-plugin-documentation/209310/6) 这里讨论过。这个功能添加了吗？

提前感谢！

---

<div class="post-metadata">

**Author:** ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)\
**Post date:** [2022年九月20日 04:19 UTC](https://meta.discourse.org/t/how-can-i-see-survey-results-or-responses/239403/4 "2022-09-20T04:19:38Z")

</div>

> [@Pandiyan](#):
>
> 有人能帮我看看这个调查的响应或结果吗？

目前，调查插件没有后端用户体验来查看调查结果。为此，我们依赖于 [Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566) 查询。示例：

```plaintext
-- [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

```

---

<div class="post-metadata">

**Author:** ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)\
**Post date:** [2024年五月15日 18:31 UTC](https://meta.discourse.org/t/how-can-i-see-survey-results-or-responses/239403/5 "2024-05-15T18:31:27Z")

</div>

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