Details of filters in effect to display on webpage and exported Excel and PDF Reports

Larry27

https://www.baldwinproject.ca/app/on/municipal_list.php
https://debug.datatables.net/ozerih
Error messages shown:
I'm trying to add the details of the active filter in effect when I export an Excel or PDF.

For example, If I filter to see municipalities with populations of less than 500, and I would like to see that printed on the exported report so anyone reading the report knows the basis of the report, i.e. All municipalities with less than 500 population

colin

That should happen automatically, as shown in this example - here it's using SearchBuilder but the same would apply with any filtering.

For complete control of the exported rows, this example (from this thread) should help. There, it's only exporting records where Office equals London, but you can add any logic into the exportOptions method,

Colin