problems with editing although idSrc, rowId are set

bayeni

I have 2 tables company and contact. Company has a numeric id as primary key and everything is working. But contact has as primary key company (the id from the company table) + name (of the contact person). If the user selects a company in the company table, in a second table the coresponding contacts are shown. That is working, but for editing it shows "Unable to find row identifier", but rowId and idSrc are set and they are unique for the shown entries in the contact table, because only the contacts of the selected company are shown. With the select column I can't move id.name as the first column.

contactTable = $('#contactTable').DataTable( {
   dom: "Blfrtip",
   ...
   rowId: "id.name",
   idSrc: "id.name",
   columns: [
   {  data: null,
      defaultContent: '',
      className: 'select-checkbox',
      orderable: false,
   },
   { title: "Name", 
     data: "id.name" 
   },
   { title: "Company", 
     data: "id.company",
     visible: false
    },
   { title: "Department", 
     data: "department" 
   },
    ...
   ],
    ...
 });

I can see in the table on the page, that the name is used as row id:
<tr id="Mr. Andreas Fries" role="row" class="odd selected"><td class="select-checkbox sorting_1"></td><td>Mr. Andreas Fries</td><td>xx</td><td>xx@xx</td><td>xx</td><td>xx</td><td></td></tr>

You wrote in https://datatables.net/manual/tech-notes/14 that it could be a combination of fields, too, but I don't know how to use a combination.

Unfortunately it is not possible to send you a link, becuase it is an internal application, but I could create debug information, if that could help.

Thanks for Information.

bayeni

I fear the problem occurs because name includes blancs. what can I do in this situation?

rduncecb

If id.name includes blanks it's not suitable to be used as idSrc as the the data element must have value and be unique.

bayeni

I tried to use as identifier

            rowId: function ( row ) {
                  return row.index();
                },

instead, but I get the information "row.index is not a function"

bayeni

I understood that I only need a unique row id for the editor. With

rowId: function ( row ) {
   no = no +1;
    return no;
},

I get row ids:
<tr id="10" role="row" class="odd"><td class="sorting_1">Mr. Krauß</td><td>xx</td><td></td><td>xx</td><td></td><td></td></tr>
but I fear I need the same if idSrc, because the error message is still "Unable to find row identifier". And which arguments have the function, if I use idSrc: function(...){}?

bayeni

both values of idSrc and rowId need to be the same. Can I insert a not visible dummy column with the row index? How can I do that?

bayeni

I could create a dummy column in front of the data columns, but without setting rowId and idSrc, it is not taken as key for editor. But it isn't used as row id if I try to set rowId and idSrc to this column, too.

contactTable = $('#contactTable').DataTable( {
   dom: "Blfrtip",
   ...
   rowId: "rowNo",
   idSrc: "rowNo",
   columns: [
   { title: "Row Number",
     name: "rowNo",
     data: "rowNo",
      render: function () {
         no = no +1;
         return no;
       }
    },
...
});

"no" is set to 0, before the data is loaded.
I tried it instead of rendering with the function as data, too. Result is the same, the column is ok, but not used as the key.
Is it not possible to use a dummy column to be able to edit the data? How can I solve that without changing the real data table?

allan

idSrc: "id.name",

This is an Editor property. It needs to be in your Editor options, not the DataTable options. Without it, Editor is using the default of DT_RowId, which is what is causing the issue.

Allan

bayeni

with id.name it don't work, because name includes blancs, that is what I used first. But I think with this dummy column with a kind of line numbers, should work. But it don't use rowNo as id for the row.

allan

You should have rowId and idSrc point to the property in your data source objects that contain the primary key value for the database table, so each row can be uniquely identified to the server.

Allan

bayeni

But the primary key is id.name+id.company and I didn't find a hint how to use a combination as rowId and idSrc.

allan

If you are using the PHP or .NET libraries for Editor, information on using a compound key can be found here.

If you are using your own server-side software you would need to combine the values at the server-side since a DOM element can only have a single id attribute.

Allan

bayeni

thanks for the information