Search

if (oTable.fnSettings().oFeatures.bServerSide == true) { console.log('filterdata', filterData); var settings = oTable.fnSettings(); $(oTable[0]).on('preXhr.dt', function ( e, settings, data ) { var filter = []; Object.keys(filterData).forEach(function(key,index) { filter.push({name: key, value: filterData[key]}) }); $.extend(data, { filter: filter }); console.log('testdraw', settings.iDraw); });

I think you would need to replace the default XSS filter with something like HTMLPurifier. Allan

hI, i fix it changing this line return Json(new { /*draw = draw, recordsFiltered = totalRecords,*/ recordsTotal = totalRecords, data = data }, JsonRequestBehavior.AllowGet); but now the records filter dont work show me "Showing 0 to 0 of 0 entries" always

processing: true, responsive: true, filter: false, serverSide: true, autoWidth:

will include any custom filtering information (since its basically

aButtons": [{"sExtends": "xls", "oSelectorOpts": { "filter": "applied" }},{"sExtends": "pdf", "oSelectorOpts":

is because the select filter is placed in the

it for display, sort, filter, etc, so yes, it

Sounds like you might need to use columns.render to pull the text out for the filter data type. Some examples can be seen here: https://datatables.net/manual/data/renderers#Functions Kevin

Ultimately, I wanted to display: (conquest_data -> zone_data -> “name” + “my_guild_points”) into a table that I could filter and sort as required… it’s a shame it doesn’t seem possible with data tables as they would have been perfect