sort a JavaScript/JSON object with Underscore

Question

I wanted to sort the JSON file below by specifically the trouser's stock level of each product, but I'm not sure how to write the code using the function _.sortBy, I made a start but not sure how I specifically target the stock level of the trousers. It should be the lowest stock level first. Any ideas? Thanks!

SCRIPT:

var sortedArray = _.sortBy(templateData, function(stocklevel) {
    return stocklevel[0].looks
});

JSON:

var templateData = {
    listTitle: "Shop by Look",
    looks: [
        {
            id: "Sportswear Look 1",
            products: [
                {
                    name: "Shirt",
                    pid: "50",
                    stock_level: 1,
                    image: "img/look1.jpg"
                },
                {
                    name: "Trousers",
                    pid: "40",
                    stock_level: 7,
                    image: ""
                },
            ]
        },
        {
            id: "Sportswear Look 2",
            products: [
                {
                    name: "Shirt",
                    pid: "50",
                    stock_level:5,
                    image: "img/look2.jpg"
                },
                {
                    name: "Trousers",
                    pid: "40",
                    stock_level: 16,
                    image: ""
                },
            ]
        }
    ]
}

Bergi · Accepted Answer · 2013-08-21 11:08:58Z

1

First of all, you need to sort the templateData.looks array, not the templateData wrapper object.

The iterator function given to sortBy will be called with each one of the sorted objects, i.e. the "shop" objects in here. When you want to return the stock level of the trousers, you need to get that object. If you don't know where it is, you will need to search it in the products array at first, Underscore's findWhere will help you with that.

var sortedArray = _.sortBy(templateData.looks, function(shop) {
    return _.findWhere(shop.products, {name:"Trousers"}).stock_level;
});

answered Aug 21, 2013 at 11:08

Bergi

671k162 gold badges1k silver badges1.5k bronze badges

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

10 Comments

user1937021 Over a year ago

Thanks for your help but I get this error: TypeError: _.findWhere(...) is undefined [Parar en este error] return _.findWhere(shop.products, {name:"Trousers"}).stock_level;

Bergi Over a year ago

Update your underscore version to at least 1.4.4

user1937021 Over a year ago

actually it returns this: [object Object],[object Object],[object Object],[object Object],[object Object],[object Object]

Bergi Over a year ago

Ah, I though at first it was a method not found error, but it could indeed be that _.findWhere(…) returns undefined - when nothing is found. What should happen if one of the shops does not sell trousers?

user1937021 Over a year ago

in the example I am using the stocklevels are always more than 0, if one of the products has 0 then it shouldn't be shown.

|

Collectives™ on Stack Overflow

sort a JavaScript/JSON object with Underscore

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related