column filter for search null records?

lovedhaka

we are using this.api().column().search().draw() for filter table column data? Is there any way to display data having null column records?

kthorngren

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.

'^\s*$'

Kevin

lovedhaka

You mean like this way,
this.api().column().search('^\s*$', true, false).draw();

we have set these property too
processing: true,
serverSide: true,
searching: true

and bsearchable: true for column.

Please suggest some example.

kthorngren

With serverside processing the server side scripts handle the searches. What are you using for your serverside scripts?

Kevin

lovedhaka

node js (hapi).

In server side query for column search, I'm getting where 'fieldname' like '%VAL%'