How to search for values in a table that have a many to one relation with the table that is shown

kaluosi

I need to search for values in a table that have a many to one relationship with the main table that is show with datatables. How can I send this search information to the php server side script? I will collect the search information in a form but how can i send the form information with the ajax call that is use to update the datatables?

jvretamero

You can use the ajax.data as a function, this way you "only" call ajax.reload() on the child table.

kaluosi

Thank you jv!! It works sending the extra information. I am trying to make it works with POST:

"ajax": $.fn.dataTable.pipeline({
"url" : 'server_processing.php',
"pages": 1, // number of pages to cache
"type" : "POST",
data: function ( d ) {
d.extra_search = $("#formBusqueda").serialize();
}

But i am able only to recover the information with $_GET in the php side. Why? I don't know