Search

node js (hapi). In server side query for column search, I'm getting where 'fieldname' like '%VAL%'

textbox in table the search column works fine. But

The request without columns search is like search[value]': 'dec'. The request with columns have search[value]: '' and each column have columns[0][search][value]: 'dec'

append('<option value="">Select All</option>'); table.column(idx, { search: 'applied' }).data().unique().sort().each(function (d, j)

Maybe the Range Search example will help get you started. Kevin

The searchCols option can be used to set initial column search values. Allan

Hello Allan, You can find an example here : http://webapp.rossignol.com/assortment_demo/Pages/OF/Assortment.html In Assortment.html l.42 rowData array never contains the line with inputs when searching for a value that is in an input (example: search for RO) . Thanks

options: Disable DataTables' smart search and use your own

example. With a global search it would do WHERE

one and adds the search critera from the select