Repository navigation
Excel like filtering #1167
Description
I prefer to use datatable for my Shiny projects to show data faster. In my opinion, DT package is the best option if you need speed. On the other hand, the filtering method on datatable is so primitive and useless. I wonder, is there chance to implement excel-like filtering on datatables.
It would be great, if there was a filter for each data types (For example, numeric/date column:["equal", "greater", "greater than", ...], string column: ["contain", "startswith", ...] )
I found some examples of advanced menu filter (like Excel) below:
- DataTable: excel-like filters: DataTable: excel-like filters primefaces/primefaces#12727
- Kendo UI: http://demos.telerik.com/kendo-ui/grid/filter-menu-customization
Is there a way to implement excel-like filtering with R Shiny and Datatable?
Thanks!
Images from the links I shared above:
Activity
agilly commentedon Mar 2, 2025
R's
DTlibrary provides a way to access the DataTables javascript library. Anything that's not covered there is probably not going to end up inDT, and I don't think advanced excel-like filtering is present in DataTables. I'm not a DT developer though and will let others comment.Also, calling something "primitive and useless" before asking for a feature is probably not going to predispose devs to work on said feature.
yihui commentedon Mar 3, 2025
I think the SearchBuilder extension does what you want: