ServerSide filtering with individual column using spring boot DataTablesRepository

sarath_datatables

Hi Allan,

implemented serverSide ajax filtering and working perfectly fine, but when tried individual column searching with dropdownlist,when serverSide on true the dropdownlist is just being populated with the information presented on the screen not with all the information from the table. This make sense because it is working with partial data. Is there any chance to load the dropdownlist with all the possible values on the total of the information from the table?

using the api "DatatableRepository.findAll(datatableinput)" (this call is giving 100-170 records as output, but need to populate the dropdownl for column filter without distrubing the performance.

thanks for the support
sarath

allan

Is there any chance to load the dropdownlist with all the possible values on the total of the information from the table?

Yes, you would need your initialise Ajax response to include the information about all of the options to display. Then use initComplete to create the select lists with all of those options.

Allan

sarath_datatables

hi allan suggested solution worked
thanks for the support