ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Query Report with filter gives error

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

I solved it.

I had to set the filter field as mandatory :slight_smile:

1 Like