在js中过滤json结果

Question

filter data from result of json call

I am trying to do pre-processing JSON data before feed it to the dataTables. the reason is I need to separate the source data into 3 datatables. i can do it in the server-side in java but that approach is undesirable. Please don't ask why, it is just due to load balancing calculation.

 type: "GET",
            dataType: 'json',
            contentType: 'application/json',
            success: function (data) {
                console.log(data);
                var table = $('#tbl1');
                var tableUsul = $('#tbl1Terima');
                var tableTolak = $('#tbl2Tolak');


                table.DataTable({
                    "data": data.object, // i want to maipulate this
                    "processing": true,
                    "destroy": true,
                    "pagingType": "numbers",
                    "columns": [
                        {"data": null, "class": "rowCenter"},
                        {"data": "0"},
                        {"data": "1"},
                        {"data": "2"}
                    ........

console.log(data.object) result

[
[1,"myname1","1000"],
[0,"myname2","0"],
[1,"myname5","12121"],
[1,"myname2","23455"]
]

i want to filter data.object. so in the database, the 1st column consists of 1 and 0, I want to show only 1 or only 0. i was trying to use data.filter(function(){}) but the js does not recognize the function filter.

Answer 1

you can try something like below.

var data = [
[1,"myname1","1000"],
[0,"myname2","0"],
[1,"myname5","12121"],
[1,"myname2","23455"]
];
var newArray = [];
for (i = 0; i < data.length; i++) {

 var  element = data[i]; 
if(element[0] == 1)
{ 
   newArray.push(element);
}

}
console.log(newArray)

</div>