On 2015-03-19 01:43, James Macdonell wrote:
If you want to preserve their sent emails as well, then you
have to check for the `from` column from the metadata table, though
it's
not indexed yet.
I think the legal_hold table as described is the way to go. I'd say
that'd
cover 9/10 of our hold requests from legal and risk management.
However,
those requests are always phrased "...all messages sent or received
by...".
So, in our case, we'd be altering the metadata table to add that index.
ok, I've just committed the required code to the master branch to
support
such a more granular legal hold. Make sure to extend the piler database,
and
test it.
create index metadata_idx_from on metadata(`from`);
create table if not exists `legal_hold` (
email varchar(128) default not null
) Engine=InnoDB;
Then you may find the legald hold menu under Administration.
We also get requests to search all mailboxes. Something along the
lines of:
"provide a copy of any correspondence related to: "spongebob",
"squidward",
"Krusty Krab", "slip and fall"". I have not dug deep, but I'm imaging
this
would be an addition to pilerexport where pilerexport is made
sphinx-aware
and somehow able to find all matching messages but stay under the
max_matches limit.
It's already requested in issue #504, I'll be working on it.
Janos
