fix(BOM): Sever Error due in bom query to new behaviour of db.escape in v12 (#18401)
fixes bug introduced by commit 6a7969117f1ec438f25ec5f8bfbbec10a04ef01d
diff --git a/erpnext/controllers/queries.py b/erpnext/controllers/queries.py
index 47c9f0a..57c063a 100644
--- a/erpnext/controllers/queries.py
+++ b/erpnext/controllers/queries.py
@@ -207,10 +207,10 @@
idx desc, name
limit %(start)s, %(page_len)s """.format(
fcond=get_filters_cond(doctype, filters, conditions).replace('%', '%%'),
- mcond=get_match_cond(doctype),
- key=frappe.db.escape(searchfield)),
+ mcond=get_match_cond(doctype).replace('%', '%%'),
+ key=searchfield),
{
- 'txt': "%"+frappe.db.escape(txt)+"%",
+ 'txt': '%' + txt + '%',
'_txt': txt.replace("%", ""),
'start': start or 0,
'page_len': page_len or 20