commit 943b46a759b79fd4fae9a7ada0425d7947e3f746
author Subin Tom <36098155+nemesis189@users.noreply.github.com> Tue Jun 22 14:26:36 2021 +0530
committer GitHub <noreply@github.com> Tue Jun 22 14:26:36 2021 +0530
tree 93354a94597a2c5c4cc4870b026911647032d7c8
parent c6939f37d4dccb01eb6c10025b32d8c579f9b9cc

fix: sql syntax error in get_project_name method (#26145)

erpnext/controllers/queries.py

diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 7bd739a..4ada834 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -315,7 +315,7 @@
 	return frappe.db.sql("""select {fields} from `tabProject`
 		where
 			`tabProject`.status not in ("Completed", "Cancelled")
-			and {cond} {match_cond} {scond}
+			and {cond} {scond} {match_cond}
 		order by
 			if(locate(%(_txt)s, name), locate(%(_txt)s, name), 99999),
 			idx desc,