Feeding table with filtered data
Feeding table with filtered data
Hi guys,
So I want to perform complex queries on my table. I already found on the forum reference to:
http://datatables.net/reference/type/selector-modifier
Which lets me to get data as is after searching., but because I want to perform more complex queries for example several different words "or'ed" together I think the easiest way will be to apply searches independently and then join results. Such prepared data can be injected back to table. Any hint how to do that?
Reinitializing table with new data set? I was looking for method 'load()' or similar but I found none. All I can do is an ajax call to get new data set (which wont work for me as I have no server side). However maybe DataTable().clear().rows.add(my_filtered_data) will do the trick? What do you think?
In return for you assistance I promise to deliver plugin that will add sql-like querying to DataTables. :)