Answers

• colin Posts: 15,144Questions: 1Answers: 2,586

  February 2019

  Hi @vimi.lad ,

  The sample you posted isn't showing the error reported - the sample is giving this error instead, "Uncaught Unable to find row identifier For more information, please refer to https://datatables.net/tn/14". This is because there isn't a unique identifier for each row - idSrc gives more details. Could you generate the error that you reported in another fiddle?

  Cheers,

  Colin
• vimi.lad Posts: 10Questions: 2Answers: 0

  February 2019

  Thanks for reply.
  Ok so my JSON is not having DT_RowId variable.

  Cool..
  Now I have added JSon from given example
  https://editor.datatables.net/examples/inline-editing/join.html
  only.

  Here is sample for inline editor
  http://live.datatables.net/huvalima/8/edit

  It is not giving any error but it is showing "No data available in the table".

  You can find data in JSON format in first line of Javascript

  var Data = '{"data": [ {"DT_RowId": "row_1","users": { "first_name": "Quynn", "last_name": "Contreras", "phone": "1-971-977-4681", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_7","users": { "first_name": "Xantha", "last_name": "George", "phone": "1-106-884-4754", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_13","users": { "first_name": "Lael", "last_name": "Kim", "phone": "1-626-697-2194", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_19","users": { "first_name": "Mona", "last_name": "Terry", "phone": "1-443-179-7343", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_25","users": { "first_name": "Ishmael", "last_name": "Crosby", "phone": "1-307-243-2684", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_31","users": { "first_name": "Quinn", "last_name": "Mccall", "phone": "1-808-916-4497", "site": "1"},"sites": { "name": "Edinburgh"} }, {"DT_RowId": "row_2","users": { "first_name": "Kaitlin", "last_name": "Smith", "phone": "1-436-523-6103", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_8","users": { "first_name": "Bryar", "last_name": "Long", "phone": "1-918-114-8083", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_14","users": { "first_name": "Lyle", "last_name": "Lewis", "phone": "1-231-793-3520", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_20","users": { "first_name": "Medge", "last_name": "Patterson", "phone": "1-636-979-0497", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_26","users": { "first_name": "Quintessa", "last_name": "Pickett", "phone": "1-801-122-7471", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_32","users": { "first_name": "Alexa", "last_name": "Wilder", "phone": "1-727-307-1997", "site": "2"},"sites": { "name": "London"} }, {"DT_RowId": "row_3","users": { "first_name": "Cruz", "last_name": "Reynolds", "phone": "1-776-102-6352", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_9","users": { "first_name": "Kuame", "last_name": "Wynn", "phone": "1-101-692-4039", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_15","users": { "first_name": "Veronica", "last_name": "Marks", "phone": "1-750-981-6759", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_21","users": { "first_name": "Perry", "last_name": "Gamble", "phone": "1-440-976-9560", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_27","users": { "first_name": "Ifeoma", "last_name": "Mays", "phone": "1-103-883-0962", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_33","users": { "first_name": "Rhonda", "last_name": "Harrell", "phone": "1-934-906-6474", "site": "3"},"sites": { "name": "Paris"} }, {"DT_RowId": "row_4","users": { "first_name": "Sophia", "last_name": "Morris", "phone": "1-463-224-1405", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_10","users": { "first_name": "Indigo", "last_name": "Brennan", "phone": "1-756-756-8161", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_16","users": { "first_name": "Wynne", "last_name": "Ruiz", "phone": "1-983-744-5362", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_22","users": { "first_name": "Pandora", "last_name": "Armstrong", "phone": "1-197-431-4390", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_28","users": { "first_name": "Basia", "last_name": "Harrell", "phone": "1-528-238-4178", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_34","users": { "first_name": "Jocelyn", "last_name": "England", "phone": "1-826-860-7773", "site": "4"},"sites": { "name": "New York"} }, {"DT_RowId": "row_5","users": { "first_name": "Kamal", "last_name": "Roberson", "phone": "1-134-408-5227", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_11","users": { "first_name": "Avram", "last_name": "Allison", "phone": "1-751-507-2640", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_17","users": { "first_name": "Jessica", "last_name": "Bryan", "phone": "1-949-932-6772", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_23","users": { "first_name": "Pandora", "last_name": "Briggs", "phone": "1-278-288-9221", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_29","users": { "first_name": "Hamilton", "last_name": "Blackburn", "phone": "1-676-857-1423", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_35","users": { "first_name": "Vincent", "last_name": "Banks", "phone": "1-225-418-0941", "site": "5"},"sites": { "name": "Singapore"} }, {"DT_RowId": "row_6","users": { "first_name": "Dustin", "last_name": "Rosa", "phone": "1-875-919-3188", "site": "6"},"sites": { "name": "Los Angeles"} }, {"DT_RowId": "row_12","users": { "first_name": "Martha", "last_name": "Burgess", "phone": "1-971-722-1203", "site": "6"},"sites": { "name": "Los Angeles"} }, {"DT_RowId": "row_18","users": { "first_name": "Quinlan", "last_name": "Hyde", "phone": "1-625-664-6072", "site": "6"},"sites": { "name": "Los Angeles"} }, {"DT_RowId": "row_24","users": { "first_name": "Maris", "last_name": "Leblanc", "phone": "1-936-114-2921", "site": "6"},"sites": { "name": "Los Angeles"} }, {"DT_RowId": "row_30","users": { "first_name": "Dexter", "last_name": "Burton", "phone": "1-275-332-8186", "site": "6"},"sites": { "name": "Los Angeles"} }, {"DT_RowId": "row_36","users": { "first_name": "Stewart", "last_name": "Chan", "phone": "1-781-793-2340", "site": "6"},"sites": { "name": "Los Angeles"} }],"options": { "users.site": [{ "label": "Edinburgh", "value": "1"},{ "label": "London", "value": "2"},{ "label": "Los Angeles", "value": "6"},{ "label": "New York", "value": "4"},{ "label": "Paris", "value": "3"},{ "label": "Singapore", "value": "5"} ]},"files": []}';

  can you guide me what is the issue in JSON data so it is not binding to table?
• kthorngren Posts: 20,309Questions: 26Answers: 4,770

  February 2019

  When using data you need to provide the full path into the variable. It doesn't look for a data object like ajax does. Use this instead data: jsonRes.data,. Here is an updated example:
  http://live.datatables.net/valaxelo/1/edit

  Kevin
• vimi.lad Posts: 10Questions: 2Answers: 0

  February 2019

  Hi Kthorngner,
  Thanks for reply and resolution. Ok .Now table is binding with data.
  But I also want to bind drop down with data mentioned inside "options" > "users.site"

  How can we bind that? Dropdown 'Location' is not filling with data while editing.
  you can refer sample at
  http://live.datatables.net/valaxelo/2/edit

  Kindly give me solution and also suggest me best way to bind table to achieve all scenarios.
• allan Posts: 61,726Questions: 1Answers: 10,109 Site admin

  February 2019

  You need to use the field().update() method of the select field type. Editor can listen for the xhr event that DataTables triggers, but that's not triggered if you are just loading the data using data.

  editor.field('users.site', data.options['users.site']);
  

  should do it.

  Allan