Unanswered Filter

[Moin]

데이터 탐색기를 사용하여 해당 주제들을 가져올 수 있습니다.

스태프가 답변하지 않은 주제 필터링

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 …