Arrange JSON objects within an array based on the values of three specific fields

Question

Arrange JSON objects within an array based on the values of three specific fields

Within an array, I am working with the following structure:

[
    {
        "playerName": "Stack",
        "leaguePoints": 100,
        "wins": 280,
        "miniSeries": {
            "progress": "WNN",
            "losses": 0,
            "wins": 1
        }
    },
    {
        "playerName": "Overflow",
        "leaguePoints": 90,
        "wins": 280
    }
    {
        "playerName": "StackOverflow",
        "leaguePoints": 0,
        "wins": 100
    }
]

To sort the array elements properly, follow these guidelines:

If leaguePoints = 100, sort by (miniSeries.wins + miniSeries.losses) or number of Ns left in miniSeries.progress

If leaguePoints is less than 100, sort by leaguePoints

If leaguePoints equals 0, sort by wins

I've tried using Ege Özcan's multiple parameters sort, which works for leaguePoints and wins, but not for miniSeries.

The desired outcome should resemble this:

Name    leaguePoints    Wins    MiniSeries
Stack   100             10      LWN
Stack   100             25      WNN
Stack   100             5       NNN
Stack   99              50      ---
Stack   70              250     ---
Stack   0               300     ---
Stack   0               200     ---
Stack   0               100     ---

javascript arrays json sorting

Answer 1

Answer №1

Perhaps what you are seeking is

function sortByProgress(a, b) {
    // Compare number of "N"s in each value
    return b.split("N").length - a.split("N").length;
}
function sortByMiniSeries(a, b) {
    // Sort by total games played
    return a.wins + a.losses - (b.wins + b.losses) || sortByProgress(a.progress, b.progress);
}
function sortByRank(a, b) {
    // Arrange by league standings
    return a.leaguePoints - b.leaguePoints || (a.leaguePoints == 0
      ? a.wins - b.wins
      : (a.leaguePoints == 100 
        ? sortByMiniSeries(a.miniSeries, b.miniSeries)
        : 0 ) );
}
playerArray.sort(sortByRank);

The || operator uses short-circuit evaluation, where the right operand is returned if the left one is falsy (in this case: 0, indicating equal values).

Answer 2

Perhaps what you are seeking is

function sortByProgress(a, b) {
    // Compare number of "N"s in each value
    return b.split("N").length - a.split("N").length;
}
function sortByMiniSeries(a, b) {
    // Sort by total games played
    return a.wins + a.losses - (b.wins + b.losses) || sortByProgress(a.progress, b.progress);
}
function sortByRank(a, b) {
    // Arrange by league standings
    return a.leaguePoints - b.leaguePoints || (a.leaguePoints == 0
      ? a.wins - b.wins
      : (a.leaguePoints == 100 
        ? sortByMiniSeries(a.miniSeries, b.miniSeries)
        : 0 ) );
}
playerArray.sort(sortByRank);

The || operator uses short-circuit evaluation, where the right operand is returned if the left one is falsy (in this case: 0, indicating equal values).

Answer 3

Answer №2

It would be beneficial to implement a 2 pass processing method.
Firstly, separate the data into 3 distinct groups: leaguePoints100, leaguePoints0, and the remaining data.

You are capable of sorting each group individually, then utilize Array.concat() to combine the three sorted arrays, view an example here.

Lo-Dash can simplify the tasks, beginning with groupBy() on leaguePoints:

groups = _.groupBy(data, function(item) {
  switch (item.leaguePoints) {
    case 100:
        return 'leaguePoints100';
    case 0:
        return 'leaguePoints0';
    default:
        return 'other';
  }
);

Following that, apply sortBy() on the three groups:

groups['leaguePoints100'] = _.sortBy(group['leaguePoints100'], sortLeaguePoints100);
groups['leaguePoints0'] = _.sortBy(group['leaguePoints0'], 'wins');
groups['other'] = _.sortBy(group['other'], 'leaguePoints');

This approach enhances the readability of the code, although it may seem somewhat repetitive.
KISS, my friend.

Answer 4

It would be beneficial to implement a 2 pass processing method.
Firstly, separate the data into 3 distinct groups: leaguePoints100, leaguePoints0, and the remaining data.

You are capable of sorting each group individually, then utilize Array.concat() to combine the three sorted arrays, view an example here.

Lo-Dash can simplify the tasks, beginning with groupBy() on leaguePoints:

groups = _.groupBy(data, function(item) {
  switch (item.leaguePoints) {
    case 100:
        return 'leaguePoints100';
    case 0:
        return 'leaguePoints0';
    default:
        return 'other';
  }
);

Following that, apply sortBy() on the three groups:

groups['leaguePoints100'] = _.sortBy(group['leaguePoints100'], sortLeaguePoints100);
groups['leaguePoints0'] = _.sortBy(group['leaguePoints0'], 'wins');
groups['other'] = _.sortBy(group['other'], 'leaguePoints');

This approach enhances the readability of the code, although it may seem somewhat repetitive.
KISS, my friend.

Arrange JSON objects within an array based on the values of three specific fields

Answer №1

Answer №2

Similar questions

Creating a JSON Response Using PHP API

Develop a scrambled PHP webpage for a CAPTCHA system

The select dropdown does not automatically refresh when the array value changes

What could be causing a momentary 404 error when I click on a next.js `Link` that connects to an API endpoint before redirecting to the intended page?

Differences between x-www-form-urlencoded and JSON in HTTP POST requestsWhen

Creating dynamic dropdown menus within a Rails 3 form using Prototype and incorporating database queries

Variety of properties determined by a "type" prop, expanding variations based on a value from the interface

Save information from an HTTP request made with a manually entered URL

How can I use Ajax to show only one div on the entire page while keeping the CSS and other header content intact

Python script for converting log.txt file to JSON

`Establish a hierarchical structure by incorporating a new value across multiple arrays`

What is the most efficient way to prevent duplicate items from being added to an array in a Vue 3 shopping cart

Retaining user interactions through cookies

Retrieving the final element from a TypeScript JSON array

Access another key within an object

Exploring Javascript: Understanding the Contrast Between Function and Class

Reverse a filter within an ng-repeat loop - AngularJS

Change the navbar brand in Bootstrap to be hidden on small screens like mobile devices

Struggling with integrating JSON data into JqGrid

Guide on incorporating Bootstrap JS into HTML5 reusable web elements