Jquery Datatable Editable Dropdown columns

Jquery Datatable Editable Dropdown columns

BackyBacky Posts: 8Questions: 0Answers: 0
edited January 2014 in Editor
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
}


]
});

Replies

  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    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
  • BackyBacky Posts: 8Questions: 0Answers: 0
    Thank you for your response. Does data table have anything which can perform CRUD?
  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    Yes - Editor: https://editor.datatables.net/

    Allan
  • BackyBacky Posts: 8Questions: 0Answers: 0
    This is not open source?
  • allanallan Posts: 61,446Questions: 1Answers: 10,054 Site admin
    No - Editor is commercial software, and, in part, pays for the development of the rest of DataTables and itself.

    Allan
  • BackyBacky Posts: 8Questions: 0Answers: 0
    Thank you for the information.
This discussion has been closed.