commit c47745ea83b19d956244ae79de39e836a4cdd61a
author Zarrar <zarrar65@gmail.com> Mon Dec 04 19:23:20 2017 +0530
committer Nabin Hait <nabinhait@gmail.com> Mon Dec 04 19:23:20 2017 +0530
tree c42c8671cb86d8df3ef30e6b9cc10fd7999b1b58
parent 406cb920ae0bf9fbe691b8c53e7bee3a268b1a66

only fetch distinct names of events (#11846)

erpnext/selling/doctype/sales_order/sales_order.py

diff --git a/erpnext/selling/doctype/sales_order/sales_order.py b/erpnext/selling/doctype/sales_order/sales_order.py
index c9e7733..bb6b0a0 100644
--- a/erpnext/selling/doctype/sales_order/sales_order.py
+++ b/erpnext/selling/doctype/sales_order/sales_order.py
@@ -668,7 +668,7 @@
 
 	data = frappe.db.sql("""
 		select
-			`tabSales Order`.name, `tabSales Order`.customer_name, `tabSales Order`.status,
+			distinct `tabSales Order`.name, `tabSales Order`.customer_name, `tabSales Order`.status,
 			`tabSales Order`.delivery_status, `tabSales Order`.billing_status,
 			`tabSales Order Item`.delivery_date
 		from