Searching / filtering undelete emails with RocksDB store

[HeWhoWatches]

The undelete emails function is likely to prove very useful, but at the moment there isn't a search or filter function, which limits its usefulness.

The context in this case is that the emails disappeared from a group mailbox (folder), and I can't find anything in the logs to indicate whether it was user error or something else. In the undelete section of the UI there are too many pages of emails to check through unfortunately, so I've restored what I could a different way.

There was the possibility of the data having been moved in error, so I had thought about globally searching all accounts for a string, but the store is RocksDB, and I've found that it doesn't seem to be an easy thing to query at present. I did look into the possibility of using a Python script in combination with the API to attempt a query, but I wasn't able to get beyond the authentication stage.

Please does anyone have any bright ideas how I can manage this better in future if this sort of thing happens again?
So, if a set of emails in a mailbox goes missing how can we:

• determine whether a user has accidentally moved / deleted the data?
• determine whether the email data may still exist in the system (i.e. global search)?
• properly leverage the undelete function to filter / search for missing emails?

I'd be interested to know what other people do, suggested best practice, etc.

[mdecimus]

Feel free to open an enhancement request with any suggestions.

[HeWhoWatches]

Thanks @mdecimus - I've split this into two feature requests, one for undelete enhancements and the other for a global search function:
#1996
#1997