Page 1 of 1

Deleting all Draft posts ?[Resolved]?

Posted: Tue Jul 28, 2020 8:05 pm
by MichaelRpdx
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.

Re: Deleting all Draft posts ?[Resolved]?

Posted: Fri Jul 31, 2020 2:31 pm
by onli
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.