I am trying to use the query report and filters introduced in version 13
the report is working OK when I write quey without filters.
after adding the filters, and I replace the value with the filter fieal name I get :
KeyError:
My query is:
SELECT posting_date,account, debit AS `Debit`,credit AS `Credit`,
SUM(credit-debit) over (PARTITION BY account ORDER by posting_date rows
unbounded preceding) AS `Balance`
FROM `tabGL Entry`
WHERE `account` = %(acc)s;
acc is the filter field name. which is of type link refering to Account doctype.
What am I missing