Problem with global search with server side and arabic letters

dinokljuco

Hi to everyone!

I have a strange issue with datatables I'm trying to search for data with option serverSide: true. Results are sometimes shown that are not related to a search input, and when search input is in arabic (site is multilingual), "No matching records found" is displayed. If I set serverSide to false, search results are accurate (even on arabic), but then data table is slow on initial load.

my datatable setup is :

ajax: '/admin/documents/datatable',
pageLength : 20,
scrollY: '50vh',
scrollX: true,
scrollCollapse: true,
bLengthChange: false,
dom: 'BfrtiS',
buttons: [
   'copy', 'csv', 'excel', 'pdf'
],
processing: true,
serverSide: true,
stateSave: true,
deferRender: true,
scroller: {
    loadingIndicator: true
},

Does anybody have an idea what is going on?

Many thanks...

trevoc

If you look into the ssp.class.php file that I'm assuming you are using, you'll see the "Searching / Filtering" section around line 140.

In those comments you will see it explained that using this class and the code in this section does not filter like the default built-in dataTables which filters word by word on any field.

So, the searching built into the ssp.class is working as designed, but obviously much different than the default filtering.

Of course my answer won't help you get that type of search working on server side processing,...

but that is what is going on..

Just realized this is from July. Did you resolve this yet?