Unfortunately the user has punched filter Supplier: “\” Now I could not update or replace filter with Supplier: “”,
I am sharing the data exported via sql query, please help me resolve this issue please.
{“updated_on”: “Tue Jun 03 2025 08:42:59 GMT+0530”, “List”: {“filters”: [[“Purchase Order”, “supplier”, “=”, “\”]], “sort_by”: “modified”, “sort_order”: “desc”}, “last_view”: “List”, “Report”: {“fields”: [[“workflow_state”, “Purchase Order”], [“name”, “Purchase Order”], [“docstatus”, “Purchase Order”], [“supplier_name”, “Purchase Order”], [“supplier”, “Purchase Order”], [“company”, “Purchase Order”], [“transaction_date”, “Purchase Order”], [“grand_total”, “Purchase Order”], [“status”, “Purchase Order”], [“per_billed”, “Purchase Order”], [“per_received”, “Purchase Order”], [“currency”, “Purchase Order”], [“base_grand_total”, “Purchase Order”]], “filters”: , “order_by”: “tabPurchase Order.modified desc”, “group_by”: null, “add_totals_row”: 0}}
While accessing the PO via GUI, it is giving this issue,
pymysql.err.ProgrammingError: (1064, “You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘’\’ ORDER BY modified DESC LIMIT 1’ at line 1”)