multiple search criteria not working in server side processing

TomasHelsen

Hi, We are struggling with tables containing up to 500 000 rows and are using serverside processing. However in the setup we use it can only handle 1 search criteria. Is this normal or are we missing something?

I noticed that the example here: https://datatables.net/examples/server_side/simple.html has the same limitation.

allan

The default server-side processing script doesn't split the search string into individual words and check to see if they are matched individually on the columns. Rather the string as a whole is checked against each column. So if I submit "tok acc" it would do LIKE '%tok acc%' against each column, rather than looking for "tok" and "acc" individually (which is what the client-side smart search does).

If you are using the Editor server-side processing scripts for PHP, then they do have this "any word, any order" ability in the code, just commented out. You can find it here. If you comment that in, make sure you comment out the default global search.

If you aren't using those files, you'd need to look at implementing that basic method in whatever script you are using.

Allan