How do I sort a JSON array by value that is nested array[].Level1.Level2 [duplicate]

Question

I need to sort a JSON array by a value which is nested. Here is the routine I am using and it always returns 0. The field value I want to sort on is advancedoptions.storeId.

orders.sort(GetSortOrder("advancedOptions.storeId"));

function GetSortOrder(prop) {  
    return function(a, b) {  
        if (a[prop] > b[prop]) {  
            return 1;  
        } else if (a[prop] < b[prop]) {  
            return -1;  
        }  
        return 0;  
    }  
}

I want to sort the JSON by storeId:

{
    "orders": [
        {
            "orderId": 415354051,
            "advancedOptions": {
                "storeId": 376480
            }
        },
        {
            "orderId": 415172626,
            "advancedOptions": {
                "storeId": 375780
            }
        },
        {
            "orderId": 414286558,
            "advancedOptions": {
                "storeId": 376480
            }
        },
        {
            "orderId": 412403726,
            "advancedOptions": {
                "storeId": 376480
            }
        }
    ]
}

Correct sort order should be:

"orderId": 415172626,
"orderId": 415354051,
"orderId": 414286558,
"orderId": 412403726,

FYI, JSON is a textual representation of an object (the result of Serialization). What you have here is an object, or a Javascript object if you want; there are no JSON objects. — Peter B
– Peter B, Commented Aug 22, 2019 at 9:44

Maxim Pyshko · Accepted Answer · 2019-08-22 14:31:10Z

0

function GetSortOrder(select) {
  return function(a, b) {
    const propA = select(a);
    const propB = select(b);
    if (propA > propB) {
      return 1;
    } else if (propA < propB) {
      return -1;
    }
    return 0;
  };
}

const orders = [
  { advancedOptions: { storeId: 34 } },
  { advancedOptions: { storeId: 342 } },
  { advancedOptions: { storeId: 3 } },
];

orders.sort(GetSortOrder(function (i) { return i.advancedOptions.storeId }));

console.log(orders);

edited Aug 22, 2019 at 14:31

answered Aug 22, 2019 at 9:46

Maxim Pyshko

5804 silver badges15 bronze badges

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

1 Comment

David Over a year ago

This code is for a google app script which supports ES5. I cannot use the arrow function technique (which I am not familiar with) what would this look like in the old Function expression way?

phuzi · Accepted Answer · 2019-08-22 09:43:20Z

0

It's the prop you're passing in, you can't access a nested property in an object how you're doing it a["advancedOptions.storeId"]. You need to do something like a["advancedOptions"]["storeId"]. The reason why your function always returns 0 is because a["advancedOptions.storeId"] is always returning undefined not satisfying your if statement.

edited Aug 22, 2019 at 9:43

phuzi

13.3k4 gold badges30 silver badges65 bronze badges

answered Aug 22, 2019 at 9:39

Dan Starns

3,8251 gold badge13 silver badges28 bronze badges

Comments

Ben · Accepted Answer · 2019-08-22 10:07:37Z

0

As mentioned, you can't access nested properties when using the bracket notation object[property]. You need to apply brackets for each layer of nesting, like object[property][propery]. When you're calling a[advancedOptions.storeId], it is returning undefined, as the correct syntax to access storeId using the bracket notation is a[advancedOptions][storeId].

If you only need to sort by one property, why not use:

orders.sort((a, b) => a.advancedOptions.storeId > b.advancedOptions.storeId)

answered Aug 22, 2019 at 10:07

Ben

272 bronze badges

1 Comment

David Over a year ago

This code is for a google app script which supports ES5. I cannot use the arrow function technique (which I am not familiar with) what would this look like in the old Function expression way?

amyd · Accepted Answer · 2019-08-22 13:35:33Z

Try this to have the data sorted by storeId

ordersData.orders.sort((a,b) => 
      a.advancedOptions.storeId < b.advancedOptions.storeId ? -1 : a.advancedOptions.storeId > b.advancedOptions.storeId ? 1 : 0
    );

var ordersData = {
    "orders": [
        {
            "orderId": 415354051,
            "advancedOptions": {
                "storeId": 376480
            }
        },
        {
            "orderId": 415172626,
            "advancedOptions": {
                "storeId": 375780
            }
        },
        {
            "orderId": 414286558,
            "advancedOptions": {
                "storeId": 376480
            }
        },
        {
            "orderId": 412403726,
            "advancedOptions": {
                "storeId": 376480
            }
        }
    ]
}
ordersData.orders.sort((a,b) => 
  a.advancedOptions.storeId < b.advancedOptions.storeId ? -1 : a.advancedOptions.storeId > b.advancedOptions.storeId ? 1 : 0
);
console.log(ordersData);

Collectives™ on Stack Overflow

How do I sort a JSON array by value that is nested array[].Level1.Level2 [duplicate]

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Linked

Related