Is there a way to include multi-column search with Server Side Processing?
Is there a way to include multi-column search with Server Side Processing?
Callz
Posts: 3Questions: 2Answers: 0
I'm using SSP datatables in the same way its described in example here:
https://datatables.net/examples/data_sources/server_side
But with that search field only works with 1 value. For example (using data from the sample link above) If I search for "Software Engineer" I get 6 results - works as intented. However when I search for "Software Engineer London" I should get 2 records - since there are 2 software engineers from London in the example data. But I'm getting "No matching records found". Is there a way to implement multi-column search?
This question has an accepted answers - jump to answer
Answers
This is the code that performs the search server-side. You'll be able to see there, that unlike it's counterpart on the client-side, the server-side search doesn't split the input into different words - therefore it doesn't do cross column search I'm afraid.
A while back, I did actually implement that for the Editor PHP libraries and that could be commented back in (and the existing global search removed) if you wanted to go that approach, or port that method over to the SSP class.
Allan