commit 12696ffeb444f4284f4a41d5f2de8b143ccba742
author mergify[bot] <37929162+mergify[bot]@users.noreply.github.com> Mon Mar 14 14:44:02 2022 +0530
committer GitHub <noreply@github.com> Mon Mar 14 14:44:02 2022 +0530
tree e8e692efd4cc4c216f04b3ab5563a5d6ce4f9987
parent d3e90ed8c81c347040a9e225ab829b3359afd621

fix: Search query of payroll entry reference in Journal Entry (#30225) (#30226)

(cherry picked from commit 98a67967a38c4e5b7b1977c4257bd0b23c57eded)

Co-authored-by: Nabin Hait <nabinhait@gmail.com>

erpnext/payroll/doctype/payroll_entry/payroll_entry.py

diff --git a/erpnext/payroll/doctype/payroll_entry/payroll_entry.py b/erpnext/payroll/doctype/payroll_entry/payroll_entry.py
index a634dfe..32b0f0f 100644
--- a/erpnext/payroll/doctype/payroll_entry/payroll_entry.py
+++ b/erpnext/payroll/doctype/payroll_entry/payroll_entry.py
@@ -719,7 +719,7 @@
 				where reference_type="Payroll Entry")
 		order by name limit %(start)s, %(page_len)s"""
 		.format(key=searchfield), {
-			'txt': "%%%s%%" % frappe.db.escape(txt),
+			'txt': "%%%s%%" % txt,
 			'start': start, 'page_len': page_len
 		})