Datatables, server side data & filtering

dmcconnell68

Hi,

I have a datatable setup and getting data from a server side PHP script. If I'm only pulling down 15 or so records at a time, then my selectFilters only include the values for whatever is in those 15 records. How can I paginate the data but still be able to selectFilter on any value in the DB?

AlenaLisava

Hello, @dmcconnell68

By default, options of the filters depend on the loaded data, so they will be re-gathered on any data loading.
The only solution is to set options separately:

{ id: 'section', width:250, header:[{content:"serverMultiComboFilter", options:optionsArray}]}

Here's the snippet: https://snippet.webix.com/oppbbcdi