problems with editing although idSrc, rowId are set

problems with editing although idSrc, rowId are set

bayenibayeni Posts: 48Questions: 6Answers: 0

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.

This question has an accepted answers - jump to answer

Answers

  • bayenibayeni Posts: 48Questions: 6Answers: 0

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

  • rduncecbrduncecb Posts: 79Questions: 0Answers: 17

    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.

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    I tried to use as identifier

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

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

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    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(...){}?

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    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?

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    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?

  • allanallan Posts: 41,522Questions: 1Answers: 5,198 Site admin

    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

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    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.

  • allanallan Posts: 41,522Questions: 1Answers: 5,198 Site admin

    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

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    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.

  • allanallan Posts: 41,522Questions: 1Answers: 5,198 Site admin
    Answer ✓

    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

  • bayenibayeni Posts: 48Questions: 6Answers: 0

    thanks for the information

Sign In or Register to comment.