Data Parsing / Column Cross-Referencing

kjkidd

This is probably something straight-forward to those with good knowledge of the API.

I want to filter results from a column based on "matches" from another column.

For example, from the example table http://live.datatables.net/ lets say I want to return a count of all employees over 35 who have a salary over $65,000.

I want that result to be available within the application, without the user having to do any manipulations to the interface. I have had success using the API to sum columns using footerCallback, but I haven't been able to figure out how to do multi-column cross referencing like I have described above.

Any help would be greatly appreciated.
Thanks

P.S. I have been working on this on my own code but will begin working on it using the above example http://live.datatables.net/ and periodically show my progress. (Hopefully we can solve it over the next couple days). I also think this could be a helpful reference for new users.

By the way the reason I am doing this is providing data for a stacked chart http://www.flotcharts.org/flot/examples/stacking/index.html which I am displaying on the same page as the DataTable. I have implemented many searchable fields and a chart that is dynamically updating several data views based on those searches.

kjkidd

Sorry if I confused anyone there... I took some time to play with the editor and realized I wasn't thinking about the problem too clearly in the first place. But, thankfully, I did figure it out eventually.

Here it is for anyone curious (wrote the results to the console window). Hope it helps someone :)
http://live.datatables.net/miyayeka/1/edit