Deleting all Draft posts ?[Resolved]?

[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.

[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.