how to get distinct values from json in jquery

Question

I've got a jquery json request and in that json data I want to be able to sort by unique values. so I have

{
  "people": [{
        "pbid": "626",
        "birthDate": "1976-02-06",
        "name": 'name'
      }, {
        "pbid": "648",
        "birthDate": "1987-05-22",
        "name": 'name'
      }, .....

So, far, i have this

function(data) {
  $.each(data.people, function(i, person) {
    alert(person.birthDate);
  })
}

but, I am at a total loss as to how efficiently get only the unique birthDates, and sort them by year (or any sort by any other personal data).

I'm trying to do this, and be efficient about it (i'm hoping that is possible).

Thanks

I see this all the time. instead of using function(i, person) alert(person.birthDate) use function() alert(this.birthDate) — bendewey
– bendewey, Commented Feb 5, 2009 at 19:38

bendewey · Accepted Answer · 2009-02-05 21:49:46Z

10

I'm not sure how performant this will be, but basically I'm using an object as a key/value dictionary. I haven't tested this, but this should be sorted in the loop.

function(data) {
    var birthDates = {};
    var param = "birthDate"
    $.each(data.people, function() {
        if (!birthDates[this[param]])
            birthDates[this[param]] = [];   
        birthDates[this[param]].push(this);
    });

    for(var d in birthDates) {
        // add d to array here
        // or do something with d
        // birthDates[d] is the array of people
    }
}

edited Feb 5, 2009 at 21:49

answered Feb 5, 2009 at 19:46

bendewey

40.4k13 gold badges105 silver badges127 bronze badges

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

3 Comments

pedalpete Over a year ago

Wow, that's awesome, and gets me most (or alot) of the way there, but what I'm still stuck with is once I have the uniques in an array, how can I query for the persons name using that? I'm basically trying to say get name where birthDate=d?

pedalpete Over a year ago

thanks bendeweay. This works, but I was actually hoping there was a nicer way of doing this with json, so that i could easily sort by another variable later, without recreating a new array. Oh well, this definitely works. Thanks Pete

bendewey Over a year ago

Not exactly perfect, but you can supply the birthDate as a variable if you want. I updated my sample

jeremyasnyder · Accepted Answer · 2009-02-05 20:05:51Z

7

function(data){
    var arr = new Array();
    $.each(data.people, function(i, person){
        if (jQuery.inArray(person.birthDate, arr) === -1) {
            alert(person.birthDate);
            arr.push(person.birthDate);
        }
    });
}

answered Feb 5, 2009 at 20:05

jeremyasnyder

1,4091 gold badge9 silver badges8 bronze badges

Comments

artlung · Accepted Answer · 2009-02-05 23:28:38Z

4

Here's my take:

function getUniqueBirthdays(data){
    var birthdays = [];
    $.each(data.people, function(){
        if ($.inArray(this.birthDate,birthdays) === -1) {
            birthdays.push(this.birthDate);
        }
    });
    return birthdays.sort();
}

answered Feb 5, 2009 at 23:28

artlung

33.5k19 gold badges76 silver badges124 bronze badges

Collectives™ on Stack Overflow

how to get distinct values from json in jquery

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related