I've created a query report in ERPnext with two filters: "From Order Date" and "To Order Date."

1

I’ve created a query report in ERPnext with two filters: “From Order Date” and “To Order Date.” Currently, I need to fill in both filters to generate the report. However, I want to achieve the following:

  1. Set default values for the filters, such as “This Month,” “Last Month,” or “Today().” Essentially, I want to use a “TimeSpan” for the filters.
  2. Make the filters optional. If a filter is left blank, the report should show all data. If only one filter is filled, the report should filter the data based on the filled field.