I am an admin for a discourse forum: forum.testproject.io and want to filter threads that have not yet been answered specifically by Staff members. The https://forum.testproject.io/latest?max_posts=1 URL filters out only threads with 0 replies, however, I want to be able to filter any thread that h…

Hi Karen, The query below lists all topics that have not been responded to by the Staff, even if the topic has already received a response from the community. --[params] --date :start_date = 2021-01-01 --date :end_date = 2021-12-31 SELECT t.id topic_id, category_id FROM topics t WHERE t.deleted_a…

[图片] karen1: But how would you (Discourse Staff) know that this thread is basically unanswered by you? You would need to create a Data Explorer query for this and to write the query, you’d need SQL skills or know how to write SQL queries. If Data Explorer doesn’t sound familiar to you, pleas…

Hi @osioke , Thanks for the quick response! I personally do not have SQL skills, is there anyone that can help with that from your team? (being that we are a paying customer :slight_smile: Thank you, Karen

Hello Karen, Our lower-tier plans are usually self-serve, but we can help with this. My colleague will reply with something shortly. If you’ll need some more queries, we have a wonderful Marketplace to help with this.

筛选工作人员未回复的主题

社区数据与报告

karen1 (Karen Teboulle) 2021 年11 月 1 日 16:53 3

你好 @osioke，
感谢您的快速回复！
我个人不具备 SQL 技能，请问您的团队中是否有人可以提供帮助？（毕竟我们是付费客户）

谢谢，
Karen

话题		回复	浏览量
How to show non-staff posts with zero replies Product Support	2	743	2022 年11 月 16 日
Is there a way to Search by Posts with No Staff replies on it Data & reporting sql-query	4	1672	2019 年8 月 17 日
How to find topics without a reply from someone other than the topic owner? Product Support	0	1324	2021 年2 月 15 日
How to filter topics by user group Data & reporting sql-query	7	1001	2023 年6 月 6 日
How to find my replies that didn't get a reply? Product Support	5	981	2017 年7 月 18 日

筛选工作人员未回复的主题

相关话题