Delete email with imported with future date

[Cassio Simões]

Hi again :)

I have some unimportant emails (mostly SPAM) that was imported with a future date (please check attachment).

Is there anyway I can delete them?

Cassio

[Janos SUTO]

Yes, there's a way to delete them. Update the metadata table, and set the retained column to yesterday, then run the pilerpurge utility.

[Janos SUTO]

Btw. it's the best to create an archiving rule matching those unimportant emails to prevent them reaching the archive at all.

[Janos SUTO]

update metadata set retained=1428995147 where id=1234;

or you may use the piler id as well:

update metadata set retained=1428995147 where piler_id='400000000000.......';

Both id and piler_id should refer to the message you want to get rid of,

[Janos SUTO]

1428995147 is a timestamp value. To figure out the id and piler_id, perhaps the simplest is to run an sql query like, select id, piler_id, from, subject, spam from metadata limit 0,100;