Datatable Filter listbox contain [object Object] when data: null is used for column
Datatable Filter listbox contain [object Object] when data: null is used for column
Lapointe
Posts: 430Questions: 81Answers: 4
columns: [
{data: 'operations.Libelle' },
{data: 'lots.Numero' },
{
data: null,
render: function ( data, type, row ) {
return ((data.PresCiv.Libelle)?data.PresCiv.Libelle+' ':'')+data.prescripteurs.Nom+' '+data.prescripteurs.Prenom;
}
},
{
data: null,
render: function ( data, type, row ) {
return ((data.ProsCiv.Libelle) ? data.ProsCiv.Libelle+' ':'')+data.options.Nom+' '+data.options.Prenom;
}
,editField: ['options.Nom', 'options.Prenom']
},
{data: 'options.Date'}
],
order: [[ 6, 'desc' ], [ 5, 'desc' ]],
columnDefs: [{target: [4,5,6,7]}],
....
initComplete:
function () {
if (savedSelected) {
this.api().rows(savedSelected).select();
this.api().state.save();
}
this.api().columns([0,1,2,3]).every( function () {// afficher les listbox de filtrage pour les colonnes concernées
var column = this;
var select = $('<select><option value=""></option></select>')
.appendTo( $(column.footer()).empty() )
column.data().unique().sort().each( function ( d, j ) {
var t = '<option ';
if ( (d) ){
if (savedColumnsFilters){
if (savedColumnsFilters[column[0][0]].search.search == '^'+d+'$'){
t += "selected='selected' ";
}
}
select.append( t + 'value="'+d+'">'+d+'</option>' );
}
});
});
}
This question has accepted answers - jump to:
This discussion has been closed.
Answers
The
columns.datadocs state this:For the rendered columns
datais the whole row of data. So whenselect.append( t + 'value="'+d+'">'+d+'</option>' );is executeddis the whole row of data. You will need to usecells().render()to get the rendered data for the select. Here is an example:http://live.datatables.net/naxenole/1/edit
I took the code from the footerCallback example, created a rendered column, assigned it a class. Then in the footrCallback if the column has that class I use
cells().render()to build the select. Otherwise it uses the code from the example.Kevin
Hello Kevin
Nice to read your answer.
Just api.cells throw an error, and using this.cells work fine.
Thanks for your help
Footer Callback sample is very interresting...
Thanks again
I have this at the top of initComplete:
You are welcome.
Kevin