Get data from JSON object using value within

Question

My JSON is as follows:

{
    "sales": [{
        "manager": "alberic",
        "surgeon": "Dr Barry Biggins",
        "amount": "300",
        "country": "USA",
        "percent-seller": "30",
        "antiquity": "June 2017",
        "date": "6"
    }, {
        "manager": "support",
        "surgeon": "Dr Barry Biggins",
        "amount": "300",
        "country": "UK",
        "percent-seller": "20",
        "antiquity": "June 2017",
        "date": "2"
    }, {
        ...
    }]
}

I want to retrieve the objects from sales where manager = "support" and date = "2". How do I go about this in jQuery?

Thanks!

Haresh Vidja · Accepted Answer · 2016-09-21 09:55:44Z

2

Simply you can use filter() method and use your condition inside filter method function will return element if your condition become true otherwise it ignore element.

data=    {"sales": [{
          "manager": "alberic",
          "surgeon": "Dr Barry Biggins",
          "amount": "300",
          "country": "USA",
          "percent-seller": "30",
          "antiquity": "June 2017",
          "date": "6"
        }, {
          "manager": "support",
          "surgeon": "Dr Barry Biggins",
          "amount": "300",
          "country": "UK",
          "percent-seller": "20",
          "antiquity": "June 2017",
          "date": "2"
        },
       ]
      };


var matchedElements = data.sales.filter(function(element) {
   return (element.manager == 'support' && element.date == '2');
});
                   
console.log(matchedElements);
                    
//if you want to access  surgeon of first element of matchedElements
                    
console.log(matchedElements[0].surgeon);

          
//if you want to access  surgeon of all elements in matchedElements
for(i in matchedElements)           
{
console.log(matchedElements[i].surgeon);
}

edited Sep 21, 2016 at 9:55

answered Sep 21, 2016 at 9:32

Haresh Vidja

8,4713 gold badges29 silver badges44 bronze badges

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

2 Comments

user1937021 Over a year ago

thanks but how do I access surgeon from matchedElements after using it?

Haresh Vidja Over a year ago

I have modified my code for access surgeon from matchedElements :)

David Hedlund · Accepted Answer · 2016-09-21 09:28:19Z

1

You filter the sales array.

Make sure to add the polyfill from the above link if you want to support older browsers.

var matchingSales = jsonData.sales.filter(function(sale) {
   return sale.manager == 'support' && sale.date == '2';
});

answered Sep 21, 2016 at 9:28

David Hedlund

130k33 gold badges205 silver badges223 bronze badges

Comments

guradio · Accepted Answer · 2016-09-21 09:29:01Z

1

var data = {
  "sales": [{
    "manager": "alberic",
    "surgeon": "Dr Barry Biggins",
    "amount": "300",
    "country": "USA",
    "percent-seller": "30",
    "antiquity": "June 2017",
    "date": "6"
  }, {
    "manager": "support",
    "surgeon": "Dr Barry Biggins",
    "amount": "300",
    "country": "UK",
    "percent-seller": "20",
    "antiquity": "June 2017",
    "date": "2"
  }]
};


$.each(data.sales, function(i, v) {

  if (v.manager == 'support' && v.date == '2') {
    console.log(v.manager)
    console.log(v.surgeon)
    console.log(v.amount)
  }

})

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

Iterate over them using .each()

answered Sep 21, 2016 at 9:29

guradio

15.6k4 gold badges39 silver badges64 bronze badges

Collectives™ on Stack Overflow

Get data from JSON object using value within

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related