Search

Hi, did you manage to find a solution for this?

DataTables will search on the original data, so if your original data is $1,200, then you'd need to search 1,200 (i.e. with the comma). If however you use DataTables to format a number (e.g. 1200), then yes you would be able to search on just 1200. Allan

edit Sorry. Replied without refreshing to see the latest discussion. Ignore me :) Allan

A plug-in for this sort of thing was contributed a while back which might be of some interest. Allan

Turns out that example had exactly what I needed! I had the client-side columns[].data option and the editor.fields[].name option set to the same thing. I needed to add a JOIN on the server-side, add the joined field to the editor instance server-side and put the joined table's field in the columns[].data option on the client-side. All good now, thanks a ton!

Make sure they test it in browser's other than Chrome. There should never be any need to set type: 'date' and in fact I think it will be harmful to do so. Allan

Thanks. It's working now

any answer please

Looks I found it: https://datatables.net/examples/api/multi_filter.html

Okay, solved it ! The data JSON was not sent correctly to the editor as it was sent in the initialization. This thread is solved. :)