Multiple records deletion from sup panel "History"

đź’¬ General Discussion
1

[color=#0088bb]Hello.
There are excessive records accumulated by our various notification processes in account module. It saved in the sub panel “History”. Please advice, how can I select all this records and delete it (all at once)? The standard option allow me to delete only one at once. (screen below)
Thank you in advance.[/color]

2

I don’t know if there’s a way to watch emails that are not yours (email module). But you can set the deleted = 0 in the database if you just want to see them anymore. This is a query that retrieve the emails that the system has notify via workflow, at least in my system, check in yours.

SELECT * FROM `emails` WHERE `assigned_user_id` IS NULL AND `type` = 'out' AND `status` = 'sent';

if you want to set delete = 0 to them you need to do it also in all these tables

best regards

1 Like
3

[color=#0088bb]Thank you, Mike.
I will try it…[/color]

4

Just to clarify, you need to set deleted = 1, I was wrong in my first reply, sorry.

Best regards

5

[color=#0088bb]Yes. I understood that. :slight_smile:
Thanks so much
[/color]