Mass Archive of older posts
By David Unwin on Saturday, 04 February 2017
Posted in General Issues
Replies 3
Likes 0
Views 318
Votes 0
Hi,
I would like to archive some of our older posts. The only way I can see to Archive is by going to the back end of EasyBlog. Listing the posts, selecting the posts and then using the Archive Button. This is a long and tedious process. Is there any way for instance I could select all blog posts with a creation date in 2016 to be archived? I can't find anything in the documentation.
Kind regards
David
Hello David,

I am sorry but unfortunately right now there is no way to filter blog posts by specific dates from the blog listings at the back end.
Mark
·
Saturday, 04 February 2017 23:45
·
0 Likes
·
0 Votes
·
0 Comments
·
So am I right in thinking the only way to archive posts is selecting individual posts and then manually deleting each one?
Is there any way I can mass archive posts?
Kind regards
David
David Unwin
·
Sunday, 05 February 2017 15:45
·
0 Likes
·
0 Votes
·
0 Comments
·
You can run following SQL query to archive all the post under 2016.



// Remember replace #_ to your table prefix

// Set your date time if you would like to archive other year

UPDATE `#__easyblog_post` SET `state` = '2' WHERE `created` BETWEEN '2016-01-01 00:00:00' AND '2016-12-31 23:59:59';


Note : Please do a full backup from your database data before you execute this SQL query above.
Arlex Wong
·
Monday, 06 February 2017 13:41
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post