Deleting all Draft posts ?[Resolved]?

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
Posts: 2
Joined: Sun Jul 26, 2020 4:51 am
Location: Portland, Oregon

Deleting all Draft posts ?[Resolved]?

Post by MichaelRpdx » Tue Jul 28, 2020 8:05 pm

It seems this works:

Code: Select all

delete from <database_name>_entries where isdraft == 'true';
If there is a side effect, please let me know.

After importing WordPress entries I find a lot of Draft entries.

How can I bulk delete all of them? I am using the Sqlite database backend and am comfortable with manually doing it through the db interface.

If this is covered in the Documents, just tell me and I'll go find it.
MichaelRpdx - Be Appropriate && Follow Your Curiosity

User avatar
Posts: 2495
Joined: Tue Sep 09, 2008 10:04 pm

Re: Deleting all Draft posts ?[Resolved]?

Post by onli » Fri Jul 31, 2020 2:31 pm

You can also take care of this via the entry list. Filter for drafts (fitler icon at the top left), invert selection to mark all, then press delete.

Posts: 1
Joined: Tue Oct 20, 2020 6:50 am

Re: Deleting all Draft posts ?[Resolved]?

Post by roccofalk » Tue Oct 20, 2020 8:50 am

Thanks guys. It was helpful

Post Reply