How to query a JSON array with jQuery

Question

I'm trying to search and JSON output from my WordPress site, in order to get the number of posts that have a specific custom field value.

For instance, here's some JSON output:

{"posts":[
{
  "id": 21831,
  "custom_fields": {
    "us_congress_chamber": [
      "senate"
    ]
  }
},
{
  "id": 21830,
  "custom_fields": {
    "us_congress_chamber": [
      "senate"
    ]
  }
}]}

I want to count how many entries have the custom_fields=us_congress_chamber and us_congress_chamber=senate, but this is the best I could come up with from another post on SO, but it just gives 0

var json = '{"posts":[{"id": 21831,"custom_fields":{"us_congress_chamber": ["senate"]}},{"id": 21830,"custom_fields": {"us_congress_chamber": ["senate"]}}]}';

var obj = JSON.parse(json);


function countTypesForBulan(resultArray, bulanVal) {
 var i,
   types,
   count = 0;
  for (i=0, types = {}; i < resultArray.length; i++)
  if (resultArray[i].custom_fields.us_congress_chamber === bulanVal && !types[resultArray[i].id]) {
     types[resultArray[i].id] = true;
     count++;
  }
   return count;
}

alert( countTypesForBulan(obj.posts, "senate") );

Did you check some of them posted answer or waiting for new one — Balachandran
– Balachandran, Commented Jul 18, 2014 at 6:07

jogesh_pi · Accepted Answer · 2014-07-18 05:27:31Z

1

it is because

// return object
resultArray[i].custom_fields.us_congress_chamber

return and object that is not equal to "senate" that should be

// return string value
resultArray[i].custom_fields.us_congress_chamber[0]

here is your complete code

function countTypesForBulan(resultArray, bulanVal) {
 var i, types, count = 0;
  for (i=0, types = {}; i < resultArray.length; i++) {

    if ( resultArray[i].custom_fields.us_congress_chamber[0] === bulanVal &&
         !types[resultArray[i].id]) {
           types[resultArray[i].id] = true;
           count++;
    }
  }
  return count;
}

answered Jul 18, 2014 at 5:27

jogesh_pi

9,7725 gold badges40 silver badges65 bronze badges

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

1 Comment

TheIntrepidSpiff Over a year ago

I didn't realize I needed to add [0]...I figured it had to do with the fact that it was an array but I just never bothered to try that!

Balachandran · Accepted Answer · 2014-07-18 05:42:36Z

1

Use .each method in query , hasOwnProperty to check is having property of us_congress_chamber or not .$.inArray() use to check the given value is in or not in the array

 var count = 0;

    function countTypesForBulan(post) {
        $.each(post, function (j, val2) {
            if (val2.custom_fields.hasOwnProperty('us_congress_chamber') && $.inArray("senate", val2.custom_fields.us_congress_chamber) != -1) {

               // do your work or change anything if condition is satisfied 
                count++;
            }
        });
        return count;
    }

DEMO

edited Jul 18, 2014 at 5:42

answered Jul 18, 2014 at 5:37

Balachandran

9,6271 gold badge19 silver badges26 bronze badges

Collectives™ on Stack Overflow

How to query a JSON array with jQuery

2 Answers 2

1 Comment

DEMO

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related