Selecting json values with jQuery

Question

I have a json object as follows:

[{"Id":"1","Item":"Apples","PricePerKilo":"10.00"},
 {"Id":"3","Item":"Oranges","PricePerKilo":"12.00"}]

I wish to get the PricePerKilo where the Id is 3.

var fruits = jQuery("#products").data('productData');

fruits holds the json object by the way...

I will explain what I want to do in SQL, because I find it easier to explain this way

SELECT PricePerKilo From fruits WHERE Id = 3 LIMIT 1

Ry- · Accepted Answer · 2013-03-06 22:59:39Z

2

You must loop! (Also, if fruits holds the JSON and not the array [it can’t hold both] then you should use jQuery.parseJSON on it first.)

var i, fruit;

for(i = 0; fruit = fruits[i]; i++) {
    if(fruit.Id == 3)
        break;
}

fruit will contain either the fruit with the Id of 3 or undefined if it didn’t exist.

answered Mar 6, 2013 at 22:59

Ry-♦

226k56 gold badges496 silver badges504 bronze badges

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

7 Comments

Steve Over a year ago

I like this approach, but wouldn't fruit hold the last fruit object if the id didn't exist?

Ry- Over a year ago

@Steve: It’s an unusual loop :) Instead of i < fruits.length, the condition is fruit = fruits[i]. So it exits when fruit becomes undefined.

Steve Over a year ago

Ah... good call. But wouldn't that give you a JS error when trying to access Id of undefined? Shouldn't it be if (fruit && fruit.Id ==3)?

Ry- Over a year ago

@Steve: No, the loop will break before that happens. It’s like while(fruit = fruits[i]) { … }.

Gravy Over a year ago

Aaah... I think I get it now. The json provided in the question is a json object containing an array. The array index for Apples is 0 and array index for Oranges is 1. Each array index holds name/value pairs. I have to loop through the index to find my required name/value pair?

|

Steve · Accepted Answer · 2013-03-06 23:01:06Z

0

You would have to loop through your array and select the id that matches:

$.each(fruits, function(i, val){
    if (val.Id == 3) {
        // val is now the single fruit object with the id of 3
    }
});

answered Mar 6, 2013 at 23:01

Steve

8,6487 gold badges42 silver badges54 bronze badges

Collectives™ on Stack Overflow

Selecting json values with jQuery

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related