Sort part of an array by value of specific key

Hi

I'm unsure how to sort by one of the key values in this array (it's part of a bigger one) but I want to loop through ERates->In and display "RateBreak" and "Rate" BUT sort by "Hours"

I'll obviously then do the same for ERates->Out

Thanks

  "ERates": {
    "In": [
      {
        "RateBreak": "½ Hour",
        "Rate": 100,
        "Hours": 0.5,
        
      },
      {
        "RateBreak": "1 Hour",
        "Rate": 200,
        "Hours": 1,
        
      },
      {
        "RateBreak": "Overnight",
        "Rate": 1000,
        "Hours": 10
      },
      {
        "RateBreak": "15 mins",
        "Rate": 70,
        "Hours": 0.25
        
      }
    ],
    "Out": [
      {
        "RateBreak": "½ Hour",
        "Rate": 150,
        "Hours": 0.5
        
      },
      {
        "RateBreak": "1 Hour",
        "Rate": 250,
        "Hours": 1
        
      },
      {
        "RateBreak": "Overnight",
        "Rate": 1200,
        "Hours": 10
      },
      {
        "RateBreak": "15 mins",
        "Rate": 100,
        "Hours": 0.25
        
      }
    ]
  }

Open in new window

PHP

Last Comment

Julian Hansen

8/22/2022 - Mon

ste5an

12/3/2019

Use the .sort() function:

<!DOCTYPE html>
<html>
<body>
    <script>
        var obj={
            "ERates": {
                "In":  [{ "RateBreak": "½ Hour", "Rate": 100, "Hours": 0.5, },
                        { "RateBreak": "1 Hour", "Rate": 200, "Hours": 1, },
                        { "RateBreak": "Overnight", "Rate": 1000, "Hours": 10 },
                        { "RateBreak": "15 mins", "Rate": 70, "Hours": 0.25 }],
                "Out": [{ "RateBreak": "½ Hour", "Rate": 150, "Hours": 0.5 },
                        { "RateBreak": "1 Hour", "Rate": 250, "Hours": 1 },
                        { "RateBreak": "Overnight", "Rate": 1200, "Hours": 10 },
                        { "RateBreak": "15 mins", "Rate": 100, "Hours": 0.25 }]
            }
        };

        var sorted = obj.ERates.In.sort(function (a, b) { return a.Hours - b.Hours; });
        console.log(JSON.stringify(sorted, null, 1));
    </script>
</body>
</html>

Open in new window

Line 18 in modern JS

var sorted = obj.ERates.In.sort( (a, b) => a.Hours - b.Hours );

Open in new window

ASKER CERTIFIED SOLUTION

Julian Hansen

12/3/2019

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Julian Hansen

12/3/2019

@Ste5an - I thought this was a PHP question?

ste5an

12/3/2019

oops..

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

William Peck

Neil Thompson

12/3/2019

ASKER

Many thanks once again Julian you come to my assistance.

Julian Hansen

12/3/2019

You are welcome Neil.