fix: Filters in item-wise sales history report (#34145)
diff --git a/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py b/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
index 44c4d54..2624db3 100644
--- a/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
+++ b/erpnext/selling/report/item_wise_sales_history/item_wise_sales_history.py
@@ -216,7 +216,7 @@
)
if filters.get("item_group"):
- query = query.where(db_so_item.item_group == frappe.db.escape(filters.item_group))
+ query = query.where(db_so_item.item_group == filters.item_group)
if filters.get("from_date"):
query = query.where(db_so.transaction_date >= filters.from_date)
@@ -225,7 +225,7 @@
query = query.where(db_so.transaction_date <= filters.to_date)
if filters.get("item_code"):
- query = query.where(db_so_item.item_group == frappe.db.escape(filters.item_code))
+ query = query.where(db_so_item.item_code == filters.item_code)
if filters.get("customer"):
query = query.where(db_so.customer == filters.customer)