Only display if column includes x...

gavoh

Hi,
I am using this to display several rows of data. One of the columns is "Location".

I would like to be able to restrict the datatable so that it only shows entries where the location field includes a word or term.

eg: If location includes "Chicago" then display, otherwise do not.

Thank you
Gavin

algee

i guess this is what you are looking for:

http://datatables.net/reference/api/columns%28%29.search%28%29

gavoh

It is something I want to have hard coded in

gavoh

Never mind, solved with...

        var table = $('#example').DataTable({
"oSearch": {"sSearch": "LOCATION" }

});
$.urlParam = function(name){
var results = new RegExp('[\?&]' + name + '=([^&#]*)').exec(window.location.href);
if (!results)
{
return;
}
return results[1] || "";
};
}