DataTable is showing object object in columns

DataTable is showing object object in columns

iftikharuddiniftikharuddin Posts: 18Questions: 5Answers: 0
edited June 2018 in Free community support

I am trying to populate DataTable with my Data but DataTable is showing **object **in columns and not printing the actual values!

JSON:

https://pastebin.com/NUEaMVn3

JS:

// Init the DatTable using the Cx Admin DataTable plugin
    cx.common.data.cxAdminDataTables.EbEvaluationSymptom = $CxRecordsTable.cxAdminDataTable({
        ajaxUrl: '<?php echo $this->CxHelper->Route('eb-admin-get-evaluation-symptoms')?>',
        columns: [
            cx.common.admin.tableEditColumn('id'),
            { data: 'title' },
            { data: 'remedy' },
            { data: 'additional-remedy' },
            { data: 'date_created' }

        ],

    });

This question has accepted answers - jump to:

Answers

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736
    Answer ✓

    Looks like you have nested objects. Maybe this example will help get you started:
    https://datatables.net/examples/ajax/deep.html

    Kevin

  • colincolin Posts: 15,112Questions: 1Answers: 2,583
    Answer ✓

    Hi @iftikharuddin ,

    If you look at this example here that shows how to reference orthogonal data, it should make more sense.

    For you, remedy is an object, so instead of

    { data: 'additional-remedy' },
    

    you'll need this:

    { data: 'additional-remedy.title' },
    

    Cheers,

    Colin

  • iftikharuddiniftikharuddin Posts: 18Questions: 5Answers: 0
    edited June 2018

    @kthorngren @colin Thanks

    { data: "remedy.0.title"},
    { data: 'additional-remedy.0.title' },
    

    This prints the first element of array but how to loop through it? Because in some cases the remedy array contains more than one element! Will render help? And it also pops up this alert on loading.

    DataTables warning: table id=cx-records-table - Requested unknown parameter 'remedy.0.title' for row 6, column 2. For more information about this error, please see http://datatables.net/tn/4

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    Take a look at my one above, you don't need the 0...

  • iftikharuddiniftikharuddin Posts: 18Questions: 5Answers: 0

    @colin I tried that but it is array so therefore we need to enter index.

  • colincolin Posts: 15,112Questions: 1Answers: 2,583

    This example here shows how to deal with nested arrays. If no joy still, could link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

    Cheers,

    Colin

  • kthorngrenkthorngren Posts: 20,144Questions: 26Answers: 4,736

    Maybe columns.render will help. Take a look at the first example to create a comma separated list from an array:
    https://datatables.net/reference/option/columns.render#Examples

    Kevin

  • iftikharuddiniftikharuddin Posts: 18Questions: 5Answers: 0

    @kthorngren @colin Thank you so much for the help, this thread helped me solve my problem.

    https://datatables.net/forums/discussion/47737/how-to-access-nested-object-data-data-orthogonal-data-with-and-0-notation-in-jquery-datatables

    My new code for the 2 columns which contains nested data is:

    {data: null,
                    render: function(data, type, row, meta) {
                        var remedies = '';
                        //loop through all the row details to build output string
                        for (var item in row.remedies) {
                            var r = row.remedies[item];
                            remedies = remedies + r.title + '</br>';
                        }
                        return remedies;
    
                    }
                },
                {data: null,
                    render: function(data, type, row, meta) {
                        var additionalRemedies = '';
                        //loop through all the row details to build output string
                        for (var item in row.additionalRemedies) {
                            var r = row.additionalRemedies[item];
                            additionalRemedies = additionalRemedies +  r.title + '</br>';
                        }
                        return additionalRemedies;
    
                    }
                },
    
This discussion has been closed.