Get Unique values for json Data using jquery

Question

I have my json data as follows:

var Data = [{"Name":"a1","ID":"b1", "year":"2011"}, 
{"Name":"a2", "ID":"b2", "year":"2012"}, 
{"Name":"a3", "ID":"b3", "year":"2012"},
{"Name":"a4", "ID":"b4", "year":"2010"}];

I need to display the data as follows,

This is what I have tried: To get unique values

var uniqueGroups = {};
            $.each(Data, function () {
uniqueGroups[this.year] = this.year;
});

 $.each(uniqueGroups, function (g) {
                resultsdiv.append('<p>' + g +'</p>' );
                $.each(json.Data, function (i, memDetails) {
                    if (memDetails.year == g) {
                        resultsdiv.append('<div>' + memDetails.Name + memDetails.ID +'</div>');
                    }
                });
            });

This prints out the results but in ascending order, But I would require it to be in descending order. How can I approach this? (Even if I sort the json on the server, it is returning in ascending order)

In first place, why can't u sort and order the Collection on server by required field/property and then send it to the client side, since server side speeds are always good compared to client side? — Siva Gopal
– Siva Gopal, Commented Mar 2, 2012 at 13:25
Even if I sort it on the server, it is automatically presenting in ascending order. — Krishh
– Krishh, Commented Mar 2, 2012 at 13:26

Darin Dimitrov · Accepted Answer · 2012-03-02 13:29:42Z

3

var uniqueGroups = [];
$.each(json.Data, function () {
    var year = parseInt(this.year);
    if (uniqueGroups.indexOf(year) < 0) {
        uniqueGroups.push(year);
    };
});
uniqueGroups.sort(function(x, y) { return x < y; });

$.each(uniqueGroups, function (index, year) {
    resultsdiv.append('<p>' + year.toString() + '</p>');
    $.each(Data, function (i, memDetails) {
        if (memDetails.year == year.toString()) {
            resultsdiv.append('<div>' + memDetails.Name + memDetails.ID + '</div>');
        }
    });
});

answered Mar 2, 2012 at 13:29

Darin Dimitrov

1.0m277 gold badges3.3k silver badges3k bronze badges

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

Collectives™ on Stack Overflow

Get Unique values for json Data using jquery

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related