[email digest] [fix] [hot] only open to-do items
diff --git a/erpnext/setup/doctype/email_digest/email_digest.py b/erpnext/setup/doctype/email_digest/email_digest.py
index 066e3b5..8b17ca3 100644
--- a/erpnext/setup/doctype/email_digest/email_digest.py
+++ b/erpnext/setup/doctype/email_digest/email_digest.py
@@ -312,7 +312,7 @@
def get_todo_list(self, user_id):
todo_list = frappe.db.sql("""select *
- from `tabToDo` where (owner=%s or assigned_by=%s)
+ from `tabToDo` where (owner=%s or assigned_by=%s) and status="Open"
order by field(priority, 'High', 'Medium', 'Low') asc, date asc""",
(user_id, user_id), as_dict=True)