Using filter for Query Report in ERPNext v13

You have to define the filter in the filters section with the exact name that you use in the query
Mark the filter as mandatory. This is just to ensure the report doesn’t run with empty key value. Donot use the filter in the query until you make a refresh.
Refresh the browser once.
Run the report once.
you should now see the filter field.
Go back to the query and add the filter in the query. Whatever you have done in the query is correct.
save the query and run the report. Refresh the browser once. Just to ensure your changes are propagated.
Key in the filter value. You should now see the results.

There is a thread i have opened seeking answers to default the value for a filter. If you have already found the solution please respond.

1 Like