How to Bulk Delete Deleted Documents

#1

Hi,

How to Bulk Delete the Deleted Documents instead of one by one?

Any button and server script?

#2

Hi @Nitin_Chintamani,

If the user has system manager rights then will do it.

image
image1826×910 144 KB

Thank You!

1 Like
#3

Thank you for your reply but if I have more than 60K entries, its a very time consuming task and it also consumes my daily time limit on Frappe Cloud.

#4

In the file
/home/<erpnextUSER>/frappe-bench/apps/frappe/frappe/desk/doctype/bulk_update/bulk_update.py you could temporarily change the limit of 500 to get a longer list but even if you DO know what you’re doing, it would be very dangerous.

#5

Thanks, but deleting one by one is still a big task. There should be something like Delete All in Error Log

#6

If you want to clear things in the error log, you can try this…
mysql -uroot -p -A; #the -A speeds up opening the relevant DB

and then run the delete command something like below (tuned to your requirements[method like ‘%send_mail%’;] and with YOUR DBname[_fhjaeouy1oweyut9c4]. You can look in the table for a specific entry that you want to delete to figure out what the query should contain

use _fhjaeouy1oweyut9c4;
delete from `tabError Log` where method like '%send_mail%';
commit;
/q