Jquery Datatable Editable Dropdown columns

Backy

Hello,

I need to use 2 drop down columns in data table. when editing, I need to populate 2nd drop down based on value selected in 1st drop down. How do I get value selected in first drop down so I can populate 2nd drop down. I am using below code.

$('#myDataTable').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers"
}).makeEditable({

"aoColumns": [
{
// 1st drop dwon
indicator: 'Saving...',
tooltip: 'Click to select Country',
loadtext: 'loading...',
type: 'select',
onblur: 'submit',
loadurl: 'EngineVersionList.php',
data:"{'London':'London','Liverpool':'Liverpool','Portsmouth':'Portsmouth','Surrey':'Surrey'}",
},
{
//Need to populate 2nd drop dwon here based on what is selected in
above drop down
}


]
});

allan

Hi,

`makeEditable` is a 3rd party plug-in and not supported as part of the DataTables project. You'd probably need create an issue on that projects issue tracker, but as far as I know, that project has been deprecated.

Allan

Backy

Thank you for your response. Does data table have anything which can perform CRUD?

allan

Yes - Editor: https://editor.datatables.net/

Allan

Backy

This is not open source?

allan

No - Editor is commercial software, and, in part, pays for the development of the rest of DataTables and itself.

Allan

Backy

Thank you for the information.