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 :
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