# 마지막 답변 후 30일이 지나면 지원 주제를 자동으로 닫을까요? (답: 아니요)

**URL:** <https://meta.discourse.org/t/do-we-want-to-close-support-topics-automatically-30-days-after-last-reply-answer-no/387520>\
**Category:** Site feedback\
**Created:** [11월 4, 2025, 12:33오전 UTC](https://meta.discourse.org/t/do-we-want-to-close-support-topics-automatically-30-days-after-last-reply-answer-no/387520 "2025-11-04T00:33:20Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![ToddZ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/toddz/32/328350_2.png) [@ToddZ](https://meta.discourse.org/u/ToddZ)\
**Post date:** [11월 4, 2025, 3:06오전 UTC](https://meta.discourse.org/t/do-we-want-to-close-support-topics-automatically-30-days-after-last-reply-answer-no/387520/5 "2025-11-04T03:06:01Z")

</div>

질문해 주셔서 감사합니다, Moin!

이 플러그인은 시작 카테고리 선택기를 제공하며, 해당 카테고리에서 날짜별로 이동된 개별 주제를 나열합니다:

```sql
-- TOPICS MOVED LIST
-- [params]
-- date :start_date
-- date :end_date
-- category_id :cat_id

SELECT
  pr.user_id, pr.post_id, pr.updated_at, 
  (regexp_match(pr.modifications, 'category_id:\s*-\s*([0-9]+)\s*-\s*([0-9]+)'))[1]::int AS old_category_id,
  (regexp_match(pr.modifications, 'category_id:\s*-\s*([0-9]+)\s*-\s*([0-9]+)'))[2]::int AS new_category_id
FROM post_revisions pr
WHERE (regexp_match(pr.modifications, 'category_id:\s*-\s*([0-9]+)\s*-\s*([0-9]+)'))[1]::int = :cat_id::int
  AND pr.updated_at::date BETWEEN :start_date::date AND :end_date::date
ORDER BY pr.updated_at DESC

```

 ![move_list](https://global.discourse-cdn.com/meta/original/4X/6/3/3/6332da7794c07d902af4aa093003adfbed52fc18.png)

---

_[View the full topic](https://meta.discourse.org/t/do-we-want-to-close-support-topics-automatically-30-days-after-last-reply-answer-no/387520)._