Auto Deletion in doctype

ERPNext
1

Hi All

How to auto-delete data inside doctype after certain timeline.

2 
import frappe
from frappe.model.document import Document

class CustomDoctype(Document):
    @staticmethod
    def clear_old_logs(days=None):
        days = days or 30
        from frappe.query_builder import Interval
        from frappe.query_builder.functions import Now
        table = frappe.qb.DocType("CustomDoctype")
        frappe.db.delete(
            table,
            filters=(
                (table.modified < (Now() - Interval(days=days))) & 
                (table.status == "Completed")
            )
        )

Steps:

  1. Goto your CustomDoctype.py and add this code , also you can add filters whatever you want, set deletion days or set it from Log Setting.
  2. Next go to Log Setting doctype and add your CustomDoctype in Logs To Clear child table and set Clear Logs After Days

image
image1628×716 67.6 KB

For Reference check this Logging

3

Hi Vipul Kumar

image
image1705×800 53.6 KB

I am using ERPnext 13.34.2 version.

4

add clear_old_logs function in your .py file and migrate, then check whether your custom doctype is coming here or not

5

It’s working, Thanks a lot.