It is possible to delete blog post automatically after a certain time?

[Tobias Groß]

Hey,

it is possilbe to delete a blog post in Confluence after a certain time?

Kind regards,

Tobi

[Bob Swift [Bob Swift Atlassian Add-ons] · Accepted solution]

Confluence Command Line Interface can be used without taking Confluence offline or worrying about corrupting your database. Use the query in runFromSql. An alternative for OnDemand or if you don't want to do SQL is to use getBlogList to a csv file and a small script to select rows by date. In either case, use something like:

--action removeContent --id nnnnnnnn

[Amrta Faruqi [Atlassian]]

Hi Tobi,

The answer is no, Confluence doesn't have that functionality.

Regards,

Amrta

[Matthew J. Horn]

While it's certainly not a built in feature, you could write a SQL statement against the Confluence database that runs at some interval (as a cron job, perhaps) and cleans up/removes entries that are older than a certain date.

[Rodrigo Adami]

Matthew's answer can be used indeed. A script can be created to delete blogposts, however, note that the blogposts are inside the "content" table and this table consists of multiple FKs in the database. So, if you are willing to create a script, be sure to not violate any constraint in the process and keep the database clean.