count the number of values jQuery Datatables

Question

When I navigate to my jQuery DataTable I would like to display how many Users are pending activation. Normally I would use fnGetData with (this) however as I am not trying to do this on a click event and I am simply just trying to count the number in the entire table I'm not sure how to do it:

UPDATE: SOLUTION

$(document).ready(function () {
    var oTable = $('#example2').dataTable({
            fnInitComplete: function (oSettings, json) {

                //store table data 
                var data = this.fnGetData();

                var pendingCount = 0;
                for (var i = 0; i < data.length; i++) {
                    if (data[i][5] != null && data[i][5] == '1') {
                        pendingCount++;
                    }
                }
                $(".panel-footer #pending").val(pendingCount);
                //pass count to html
                //alert(pendingCount);
            },
        "sAjaxSource": "AjaxHandler",
        "aoColumns": [
                        { "sName": "Id" },
                        { "sName": "ProfileId" },
                        { "sName": "Type" },
                        { "sName": "Name" },
                        { "sName": "Email" },
                        { "sName": "PendingActivation" }
        ]
    });

To improve your question please specify what is going wrong with your current solution, e.g. do you get any errors or see other symptoms of failure? — Olga
– Olga, Commented Oct 1, 2015 at 19:05

Gyrocode.com · Accepted Answer · 2015-10-01 19:30:44Z

1

SOLUTION

You have some errors in your logic while calculating total count, see the corrected code below:

var data = oTable.fnGetData();

var pendingCount = 0;
for(var i = 0; i< data.length; i++){
   if (data[i][5] != null && data[i][5] == '1') { 
       pendingCount++;
   }        
}

//pass count to html
$(".panel-footer #pending").val(pendingCount);

DEMO

See this jsFiddle for demonstration.

answered Oct 1, 2015 at 19:30

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Kirsty White Over a year ago

hmm seems to be outputting 0 all the time?

Gyrocode.com Over a year ago

@KirstyWhite, my example on jsFiddle works for HTML sourced data. If you have Ajax sourced data, you need to put this code in fnInitComplete callback.

Gyrocode.com Over a year ago

@KirstyWhite, see this example with fnInitComplete which also works. Regarding your update: use this instead of oTable.

Kirsty White Over a year ago

See updated question not sure if my code is laid out correct for this

Gyrocode.com Over a year ago

@KirstyWhite, that's because you cannot initialize the table twice with dataTable(). Put fnInitComplete into the original table definition.

|

Collectives™ on Stack Overflow

count the number of values jQuery Datatables

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related