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 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:

visible it is. topic.update_status("visible", false, Discourse.system_user) Thanks guys

Unlist a topic using rails console

Product Support

Mittineague (Mittineague) January 23, 2017, 5:37am 4

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.

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