I want to get the value of the invisible cell next to the one that the user selects

MarkAinsworth

My code looks like this:

$(document).ready(function () {
$('#vendorList').DataTable({

            select: {
                style: 'os',
                items: 'cell'
            },
            ajax: {
                url: "vendors.php",
                dataSrc: ""
            },
            columns: [
                {data: "catalogManufacturer"},
                {data: "VendorNumber",
                visible: false}

            ]
        });

        //when vendor is selected, show items
        var vTable = $('#vendorList').DataTable();

        vTable.on( 'select', function (e, dt, type, indexes) {
            var idx = vTable.cell('.selected').index();

            var rowData = vTable.rows(idx.row).columns(idx.column).data();

                console.log(rowData);

        });
    });

The table is populated as expected. My json is just an array of associated arrays.

rowData appears to be the entire column at this point.

How do i get just the value for the colum

kthorngren

rowData appears to be the entire column at this point.

Basically rowData contains columns(idx.column).data() which will be all the data in that column. Using row() won't filter the data returned using column() even if chained like you have.

How do i get just the value for the colum

Use cell().data(). Maybe something like this:

var VendorNumber = vTable.cell( idx.row, 1 ).data();

Kevin

MarkAinsworth

Simple enough. Thanks, Kevin for taking the time to answer.