commit f4779df9b3a65d80754ded9d0f420dc1c76766c6
author Bhavesh Maheshwari <34086262+bhavesh95863@users.noreply.github.com> Thu Nov 03 10:59:20 2022 +0530
committer Mergify <37929162+mergify[bot]@users.noreply.github.com> Sat Nov 05 06:12:40 2022 +0000
tree a8cf23ab9f3b155e4c349ac1a638dae86cccc775
parent cbf82872fb5990d99b07013c4d2882fcc85c32b3

fix: mysql syntax issue

(cherry picked from commit 4d9bbd4c9c06811086e0ae4e2c16763fe7d171a3)

erpnext/stock/doctype/pick_list/pick_list.py

diff --git a/erpnext/stock/doctype/pick_list/pick_list.py b/erpnext/stock/doctype/pick_list/pick_list.py
index 9c1c7e5..8bad9bc 100644
--- a/erpnext/stock/doctype/pick_list/pick_list.py
+++ b/erpnext/stock/doctype/pick_list/pick_list.py
@@ -699,7 +699,8 @@
 			AND `company` = %(company)s
 			AND `name` like %(txt)s
 		ORDER BY
-			(case when locate(%(_txt)s, name) > 0 then locate(%(_txt)s, name) else 99999 end) name
+			(case when locate(%(_txt)s, name) > 0 then locate(%(_txt)s, name) else 99999 end),
+			name
 		LIMIT
 			%(start)s, %(page_length)s""",
 		{