Is it possible to use multiple values search in one column in serverside

Is it possible to use multiple values search in one column in serverside

hashsalacophashsalacop Posts: 19Questions: 5Answers: 0

I'm using ssp.class.php. If I use normal datatables This is working ``` table.columns(172).search("1|2|3|4").draw();

But when I use serverside with ssp.class.php this is not working. ``` table.columns(172).search("1|2|3|4").draw(); can anybody help me please.

Replies

  • rf1234rf1234 Posts: 2,801Questions: 85Answers: 406

    if you use server side processing your search string must match with your database contents before rendering. If you don't have "1|2|3|4" in one of your selected database fields it won't be found.

  • allanallan Posts: 61,449Questions: 1Answers: 10,055 Site admin

    The way to handle this would be to modify the server-side script to convert the submitted string into an SQL query condition - e.g. columnName = 1 OR columnName = 2 OR ....

    Allan

  • hashsalacophashsalacop Posts: 19Questions: 5Answers: 0

    how? Can you just tell me which part i could edit it Please.

This discussion has been closed.