Search

settings.nTable.id !== "tableIdOfInterest" ) { return true; } // filtering logic for `tableIdOfInterest` } ); Yes

I suppose it is an extenstion of that thread but not the same - first thread lead me to a potential solution - now I am trying to implement

thanks again @Colin, using row id's to select rows make more sense now because of the ever-changing order as you said. I'll use id's to select rows.

Hi Colin, I don't know what to say.... I'm speechless. Thank you so much for your help. That's great!! Cheers, NIklas

Hi @rahulcapgemi That live fiddle would help with this one - there's a lot going on with those columns. Cheers, Colin

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!