# Convert all existing topics in category to wikis

**URL:** <https://meta.discourse.org/t/convert-all-existing-topics-in-category-to-wikis/54493>\
**Category:** Self-Hosting\
**Tags:** how-to\
**Created:** [2016年十二月19日 13:34 UTC](https://meta.discourse.org/t/convert-all-existing-topics-in-category-to-wikis/54493 "2016-12-19T13:34:44Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)\
**Post date:** [2023年六月22日 07:17 UTC](https://meta.discourse.org/t/convert-all-existing-topics-in-category-to-wikis/54493/3 "2023-06-22T07:17:48Z")

</div>

你好 matenauta 🙂

是的，通过使用这里的逻辑可以实现：

[https://meta.discourse.org/t/administrative-bulk-operations/118349#move-all-topics-with-a-specific-tag-to-a-single-category-15](https://meta.discourse.org/t/administrative-bulk-operations/118349#move-all-topics-with-a-specific-tag-to-a-single-category-15)

示例（已测试并可用）：

```rb
TAG = Tag.find_by_name("design")
topics_id = Topic.joins(:topic_tags).where("topic_tags.tag_id = ?", tag.id).pluck(:id)
Post.where(topic_id: topics_id, post_number: 1).update_all(wiki: true)

```

---

_[View the full topic](https://meta.discourse.org/t/convert-all-existing-topics-in-category-to-wikis/54493)._