refactor: select distinct types
diff --git a/erpnext/accounts/doctype/repost_accounting_ledger/repost_accounting_ledger.py b/erpnext/accounts/doctype/repost_accounting_ledger/repost_accounting_ledger.py
index 8aaafd0..69cfe9f 100644
--- a/erpnext/accounts/doctype/repost_accounting_ledger/repost_accounting_ledger.py
+++ b/erpnext/accounts/doctype/repost_accounting_ledger/repost_accounting_ledger.py
@@ -13,7 +13,7 @@
self._allowed_types = [
x.document_type
for x in frappe.db.get_all(
- "Repost Allowed Types", filters={"allowed": True}, fields=["document_type"]
+ "Repost Allowed Types", filters={"allowed": True}, fields=["distinct(document_type)"]
)
]
@@ -200,7 +200,7 @@
filters.update({"document_type": ("like", f"%{txt}%")})
if allowed_types := frappe.db.get_all(
- "Repost Allowed Types", filters=filters, fields=["document_type"], as_list=1
+ "Repost Allowed Types", filters=filters, fields=["distinct(document_type)"], as_list=1
):
return allowed_types
return []