CODEWITHSUNDEEP
javascriptjquerydatatables
user9612020
user9612020

Reputation:

How to get all checkbox values in cells

I have jQuery datatables with some checkboxes for granting privileges. I need to get table values to a array. Please enlighten me about how to get checkbox states inside cells, not only the checked ones. Thank you.

My table 

 <table id="jqueryTable" name="tt" class="table table-striped table-bordered" cellspacing="0">
    <thead>
        <tr>
            <th name="id">
                ID
            </th>
            <th name="name">
                PRIV_Name_Str
            </th>
            <th name="create">
                Create
            </th>
            <th>
                Edit
            </th>
            <th>
                View
            </th>
        </tr>
    </thead>
<table>

My datatable query

function LoadProduct(element) {
$.ajax({
    url: '/ADM_MAS_Privilege/GetFormData',
    data: { YourValue: $('#productCategory').val() },
    method: 'post',
    dataType: 'json',
    success: function (data) {
        var table =   $('#jqueryTable').dataTable({
            paging: true,
            sort: true,
            searching: true,
            scrollY: 200,
            data: data,
            bDestroy: true,

            "columnDefs":
            [{
                "targets": [2, 3, 4],
                "render": function (data, type, row, meta) {
                    console.log("XX " + meta.row + " " + meta.col);
                    return type === 'display' ?
                        '<input type="checkbox" id="p" class="chk" name="group' + meta.row + '" /> ' + data :
                        data;
            columns: [{ "data": "ID", "ID": "ID", "autoWidth": true },
            {
                "data": "PRIV_Name_Str", "PRIV_Name_Str": "PRIV_Name_Str", "autoWidth": true
            },
            {
                "data": "Create", "Create": "Create", "autoWidth": true
            },
            { "data": "Edit", "Edit": "Edit", "autoWidth": true },
            {
                "data": "View"                 

            }

            ]
        });
    }
});

};

My jQuery function to read datatable 

$('#upload').click(function () {
var table = document.getElementById("jqueryTable");
var tableArr = [];
for (var i = 1; i < table.rows.length; i++) {
    tableArr.push({

        ID: table.rows[i].cells[0].innerHTML,
        PRIV_Name_Str: table.rows[i].cells[1].innerHTML,

        Create: table.rows[i].cells[2].innerHTML,
        Edit: table.rows[i].cells[3].innerHTML,

        View: table.rows[i].cells[4].innerHTML

    });
}

});

I tried table.rows[i].cells[2].innerHTML.getElementById("p").checked even and it's not working.

Upvotes: 1

Views: 171

Answers (2)

ninjaAF
ninjaAF

Reputation: 534

You can find the element and the checked property within each cell:

for (var i = 1; i < table.rows.length; i++) {
    var cells = table.rows[i].cells;
    tableArr.push({
        ID: cells[0].innerHTML,
        PRIV_Name_Str: cells[1].innerHTML,
        Create: cells[2].querySelectorAll('input')[0].checked,
        Edit: cells[3].querySelectorAll('input')[0].checked,
        View: cells[4].querySelectorAll('input')[0].checked 
    });
}

Upvotes: 0

kaushik94
kaushik94

Reputation: 687

Since you are using jQuery:

document.getElementById("jqueryTable").each(function (index, element) {
  tableArr.push({
    ID: element.cells[0].innerHTML,
    PRIV_Name_Str: element.cells[1].innerHTML,

    Create: element.cells[2].innerHTML,
    Edit: element.cells[3].innerHTML,

    View: element.cells[4].innerHTML
  })
})

Upvotes: 1

Related Questions