Answers

• allan Posts: 63,286Questions: 1Answers: 10,425 Site admin

  August 2023

  Thanks for the test case, it is very useful.

  If a property doesn't exist in the JSON, and DataTables is looking for it, then you need to specify columns.defaultContent for that column so DataTables knows what to show in its place.

  For example Antarctica in the JSON feed doesn't have a currency object. Adding columns.defaultContent as an empty string addresses that. A number of other rows also have properties which appear to be optional. I've updated your test case to allow for this.

  Allan
• newbieC Posts: 25Questions: 6Answers: 0

  August 2023

  Hey, thank you for that, it fixed errors on empty data cells I was getting but how do I access the "3" column which is supposedly currencies of each country. It only show "object object" being a nested object I have failed to access its properties name or symbol.

  Object.keys and values show up in console log but throws null or undefined error when I try to use the code to return the same data in datatables as mentioned above.

  Could you help me figure out how to return data or why is js function object.keys not working when trying to return data in render function?

  {
    defaultContent: '<b>No Data To Display</b>',
    data: 'currencies',
    render:function(data,type,row){
                 if(type === 'display'){
                    // console.log(data)
                    return Object.keys(data)[0]
                 else{
                    console.log(Object.keys(data)[0])
                    return Object.keys(data)[0]
                 }
              }
  }
  
• newbieC Posts: 25Questions: 6Answers: 0

  August 2023

  Also, my header on this table is not scrolling horizontally along with my data fields which is weird as I have made no changes to code or BS5 table styling in any parent or child tags, its same as my other tables and they work fine when horizontally scrolling.
• allan Posts: 63,286Questions: 1Answers: 10,425 Site admin

  August 2023 Answer ✓

  Yes, Object.keys() will throw an error if you don't pass an object in. In this case you are passing undefined. Just check if there is a value or not first: https://live.datatables.net/bibimoci/4/edit .

  Also, my header on this table is not scrolling horizontally along with my data fields

  Add scrollX: true. I've done that in the linked example above.

  Allan
• newbieC Posts: 25Questions: 6Answers: 0

  August 2023

  OH, yes. smacks head...I did not realise their were undefined objects in the json data and had to handle them as well.

  {
              data: 'currencies',
              render:function(data,type,row){
                    // console.log(Object.keys(data)[0])
                    if(data !== undefined)
                       return Object.values(data)[0].symbol + ' , ' + Object.keys(data)[0] + ' , ' + Object.values(data)[0].name
                    else 
                       return '<b>NO DATA TO DISPLAY<b>'
              
              }
             
          }
  

  THIS IS WORKING FINE NOW, thanks for your help. I appreciate it!!!