Is there a way to call a backend code when user starts searching in a column?
Is there a way to call a backend code when user starts searching in a column?

I have a datatable with search text fields under each column. Wanted to ask if there is a way to call the backend code as user starts to search in a column or combination of columns. I have 28,000 rows and it's taking a while for datatables to load the records. I just want to return 40 records first. Then as the user starts to type in search values in, say column 1, I want to call the backend to return that specific result. Any help with code sample will be appreciated!
Thanks
Sammy
Answers
Hi @Sammy1 ,
If you're
serverSide
, it will only request/load the records needed for the page being displayed. This makes it fast.Hope that does the trick,
Cheers,
Colin