Export Excel by search

hello everyone, I'm new in Mendix, I want to ask how to make an export excel in data grid 2 with filters using search
2 answers

Hi Teguh,


The best way to achieve this right not would be to setup a search helper as described in this article: https://medium.com/mendix/create-your-own-way-of-filter-by-npe-non-persistant-entity-and-microflow-4ffd11e52fb0

Using that you can filter the list displayed in your datagrid2 widget. Currently the datagrid2 widget does not have an OOTB excel export function yet, (this is on the roadmap) so you will have to create the excel export function yourself using the Excel Exporter module: https://marketplace.mendix.com/link/component/726

For the excel export, you would take the objects returned from the search based on your filter criteria and only include those in the excel export.


I hope this helps.


Better to use Data grid