commit a6e09826b39ff4c998f204224c21ccc45cae91ae
author Nabin Hait <nabinhait@gmail.com> Fri Apr 19 20:11:29 2019 +0530
committer GitHub <noreply@github.com> Fri Apr 19 20:11:29 2019 +0530
tree 248c9eac173b61781106eeb9d47b9c108f2faec2
parent 375f051b24b171c0a28609c1456ba5452e11047f
parent 1d78aae2af15e9bd7039784e9a73d047ea234615

Merge pull request #17297 from netchampfaris/index-item-route

fix: Add index to Item route

erpnext/stock/doctype/item/item.py

diff --git a/erpnext/stock/doctype/item/item.py b/erpnext/stock/doctype/item/item.py
index aa51f47..aeab9ed 100644
--- a/erpnext/stock/doctype/item/item.py
+++ b/erpnext/stock/doctype/item/item.py
@@ -1062,3 +1062,7 @@
 		count+=1
 		if publish_progress:
 				frappe.publish_progress(count*100/len(variants), title = _("Updating Variants..."))
+
+def on_doctype_update():
+	# since route is a Text column, it needs a length for indexing
+	frappe.db.add_index("Item", ["route(500)"])