we are using this.api().column().search().draw() for filter table column data? Is there any way to display data having null column records?
You would need to use regex search and turn off smart search. The following regex string should return NULL rows or rows the begin with one or more spaces (or any whitepace char) and don't have other characters.
You mean like this way,
this.api().column().search('^\s*$', true, false).draw();
we have set these property too
and bsearchable: true for column.
Please suggest some example.
With serverside processing the server side scripts handle the searches. What are you using for your serverside scripts?
node js (hapi).
In server side query for column search, I'm getting where 'fieldname' like '%VAL%'
It looks like you're new here. If you want to get involved, click one of these buttons!
DataTables designed and created by SpryMedia Ltd.
SpryMedia Ltd is registered in Scotland, company no. SC456502.