DataGrid 2 - Excel Export

Hello, I’m currently working on DataGrid 2 setting up an Excel Exporter, one of the requirements I’m stuck with is filtering the records and ONLY downloading the filtered records from the DataGrid.  Has anyone solved this? or any help on how I should approach this? Thanks.
2 answers

Hey Oliver,
Datagrid 2 doesn't have this function yet as far as I know.
But the workaround you could use is to save the filter values to a Filter helper entity. When you hit export, you can use that information to filter the retrieved list.

It would be wise to not save that entity to database, so it just uses the most current filter setup.

Think that could work for you?





Thinking out loud but here's an idea of a solution i'm going to check out :

  • I could put input e.g. month for example
  • use xpath to retrieve dates which match the month
  • then export them to excel

I'm just checking whether it can handle the more in-depth search functions like equals to, not equals to, greater than, less than etc…