Set inline filters in Frappe Datatable

Frappe Framework
1

Is there any built-in api to set the inline filters in Frappe Datatable? Else any ideas to set a value in inline filter for a column…

image
image2680×1020 195 KB

2

I managed to use functions from Datatable, add added a custom menu item to set inline filter value, and then trigger the filtering.

This could be extended for the functionality needed here

  onload: function (report) {
    report.page.add_menu_item(__("Filter Blanks"), () => {
      const dt = report.datatable,
        header = $(dt.header),
        col_manager = dt.columnmanager;
      const inline_filters = $(header).find('input[data-name="Balance (INR)"]');
      inline_filters.val("=0.00");
      col_manager.applyFilter(col_manager.getAppliedFilters());
    });
  },
5 Likes
3

inline_filter_by_value