Can't fill second table not even show buttons (add. edit,delete) on page

Pliachas Paschalis

Link to test case: http://4plus-project-demo-gr.stackstaging.com/mainpage_demoA.php
Debugger code (debug.datatables.net): https://debug.datatables.net/ahuyoq
Error messages shown:
Description of problem: On that page i can not show the buttons of the second table (tblContacts). Am i missing something?
I tried to follow the example i found here "https://editor.datatables.net/examples/advanced/parentChild.html"

colin

I might be missing something, but I'm only seeing one table. How do I access the other one?

Colin

Pliachas Paschalis

I paste the print screen from the site. The second table is below the first one (tblMembers)

colin

Ah, gotcha. The problem is because you've got an empty element in the ContactsEditor declaration for fields:

                }, {
                }, {

Colin

Pliachas Paschalis

Thanks Colin. Thanks for help.
I am trying to get the id of the Mysql table trying this code

MembersTable.on('select', function (e) {
            ContactsTable.ajax.reload();
            var pMemberId = MembersTable.row().id();
            var pMemberIdCode = pMemberId.val();
            console.log(pMemberIdCode);
            $idOfMember = MembersTable.rows({ selected: true }).data()[0]['id'];
            console.log('pas');
            console.log($idOfMember);
            console.log(MembersTable.rows({ selected: true }).data()[0]['fUser']);
            ContactsEditor
                .field('tblContacts.idMember')
                .def(MembersTable.rows({ selected: true }).data()[0]['id']);
        });

but i can't.
thanks in advance

Pliachas Paschalis

i corrected the code to this:

MembersTable.on('select', function (e) {
            ContactsTable.ajax.reload();
            var pMemberId = MembersTable.row().data()[0];
            console.log(pMemberId);
            // var pMemberIdCode = pMemberId.val();
            // console.log(pMemberIdCode);
            $idOfMember = MembersTable.rows({ selected: true }).data()[0]['id'];
            console.log('pas');
            console.log($idOfMember);
            console.log(MembersTable.rows({ selected: true }).data()[0]['fUser']);
            ContactsEditor
                .field('tblContacts.idMember')
                .def(MembersTable.rows({ selected: true }).data()[0]['id']);
        });

but with no result. I get undefined in console.

colin

var pMemberId = MembersTable.row().data()[0];

Because you haven't specified any row identifier to row(), this will only get the data for the first row in the table, not the row that was clicked.

See this example here - it's showing how to get the data for the row that was clicked,

Colin

Pliachas Paschalis

Ok i''ll try that and let you know the result. Thanks

Pliachas Paschalis

I used this approach

MembersTable.row(indexes).id().substring(4)

and finally worked. Thank you