Capture Filtered Rows - How To?

Joyrex

I'm trying to capture the rows that are showing after a user has filtered the recordset (this is NOT using server-side data) so I can use a values from the filtered rows for pagination on a detail view of those records (so the user can paginate through only the filtered data instead of the entire recordset). Any ideas or direction where I would accomplish this? I've read up on filtering by rows and columns, but nothing's clicking for me. Any help is appreciated!

allan

So you want the data from the rows that remain after filtering? The `_` method will do that: `table._( 'tr', { 'filter': 'applied' } );` . Docs: http://datatables.net/docs/DataTables/1.9.4/#_

Allan

Joyrex

Allan,

Ah, OK - I'll give this a go! Thanks!

Joyrex

OK, I understand now how this works (I think) - I get a list of filtered items (the first td in each filtered row), but two things still remain elusive to me:
- how to trigger this when someone filters the table - right now it runs immediately and the only way I can see what is being captured is via an alert, and I set the fnFilter value to something - how do I trigger it so it only captures when someone uses the filter?
- the results come back as a comma-delimited list - is there any way of appending the data to any hrefs that also exist in the filtered data with the data? I'm trying to pass the comma-delimited list of filtered records via a URL parameter to another page so I can use that as my pagination range on the new page. The documentation says the oOpts "Optional parameters for modifying the rows to be included" object can be used for that - is that correct?

Thanks again for the help!