Individual column searching (select inputs) - server side - How to have the full list in the select
Individual column searching (select inputs) - server side - How to have the full list in the select
I tested this exampe https://datatables.net/examples/api/multi_filter_select.html
The gloabal 'input search' works correctly, means it filters also data that are not shwon.
But the individaul column search does not show all the list. The items in the select list for one column are only those shown on the page, that's normal by the use of the function 'this.api().columns().every( function () {' but it's a problem because there is no way (except with the global seacrh) to search for every data, and the selected list does not render all the data available for the column.
Does sb know an other example which solves this problem? What should be the best way to do it (have pre-calculated select lists build by the server? ...
This question has an accepted answers - jump to answer
Answers
The example you linked to appears to be showing every item in its select lists, not just those shown on the current page. Or am I misunderstanding the question?
Hi @tangerine ,
Thanks for your answer, you are right, the list is complete in the example but at the end it's writen 'since the data is available in the table on load' that means, if I well understand, that it's not a server side example.
Are you sure that this example works in server side?
I'll remove all my other code in my script to retest in the same conditionof the example.
In your sever script look for the
drawparameter value being 1. That is the initial request. When the parameter is 1 then use some DB queries collect the column data and return in an additional object. Use thejsonparameter ofinitCompleteto access the additional object in the returned JSON.Kevin
Hi @kthorngren
Thanks for your reply.
I use Yajra DataTable with Infyom Laravel-Generator
I change to draw(1) in public/vendor/datatables/buttons.server-side.js
That does not solve the pb.
But I don't understand the 2nd part of your answer.
-1- From the doc of initComplete I understand that the 2 parametres 'settings & json' are no optional, so mandatory? But they are not present in the examples code and in y code !?
-2- If I add this parameters, what/how to do with the json , is there any example somewhere?
-3- Anyway, when I print json, it only shows the data on the page (10 rows)
Sorry I'm not familiar with the framework you are using. Maybe someone else on the forum is and can help. Maybe you can contact the developer of the framework to get support.
Javascript allows not passing in parameters that aren't being used.
I don't have an example but I guess you will need to use JSON.parse() to parse the JSON string into a Javascript object. Then access the object you added with the slect list information.
Thats expected with server side processing. You should see a few other properties like
draw, etc. Once you add your object for the select lists you should see it here to.Kevin
Don't undersatnd ... What is the code related in the exemple https://datatables.net/examples/api/multi_filter_select.html ?
In your server script you will need to run queries to fetch all the unique options for each column you want the select inputs. Do this when the draw parameter is
1. Return the options as an additional property, for example:in
initCompleteuse thejsonparameter to access the property you added in the server script. Sorry, I don't have a way to provide an example as I don't have a server side processing script to add the options property.Kevin
Here is a thread asking a similar question. I believe there are others on the forum. Maybe they will help.
Kevin
Many thanks @kthorngren it's clear and logic now.