We have a use case where we need to close all existing topics and unlist them. I have closed all topics using the rails console by executing Topic.where(closed: false).find_each do |topic| topic.update_status("closed", true, Discourse.system_user) end But, when I try to do the same to unlist to…

I believe you are looking for “visible”. But don’t let me stop you from learning about the database before you start running queries against it. Please save a backup just in case you need it later.

I don’t have much idea :grin: and shouldn’t say anything, but what came to me was maybe try "listed" column and set to false? at least something to try until someone else sees :grin: (or I find something while peeking around) Edit: I think I can see things like closed, visible, enabled, archived, d…

I tried the listed column. That one also does not exist. I am trying to get a peek into the table using phppgadmin now

[image] shahidh: I am trying to get a peek into the table a great idea :smiley:

Unlist a topic using rails console

Product Support

shahidh (Shahidh K Muhammed) January 23, 2017, 6:39am 6

visible it is.

topic.update_status("visible", false, Discourse.system_user)

Thanks guys

Topic		Replies	Views
Unlisting a topic in the ruby console Development unlisting	1	517	January 21, 2019
Unlisted option on creation of a new topic Feature unlisting	5	3931	March 30, 2016
Unlisted only means not listed in topics list Announcements unlisting	0	1499	August 22, 2017
Unlisted topics become listed via references Bug unlisting	9	1802	August 22, 2017
Error: PG::UndefinedColumn. Custom field not creating column Product Support	4	1638	August 11, 2021

Unlist a topic using rails console

Related topics