סינון ללא תשובות

[Moin]

You could use data explorer to get those topics

Filter topics not answered by Staff

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_at IS NULL AND t.category_id IS NOT NULL AND t.created_at::date BETWEEN :start_date AND :end_date AND t.id NOT IN ( SELECT p.topic_id FROM posts p JOIN users u ON p.user_id = u.id …