organize an array or JSON based on a numeric value or object in JavaScript

Question

organize an array or JSON based on a numeric value or object in JavaScript

I encountered an issue related to sorting in JSON data. I have a list that can be reordered and the new order needs to be saved so that when the user returns, they see the list in the same customized order. Please refer to the image below: https://i.sstatic.net/6okK3.png The ordering information gets saved in an object and upon retrieval, the JSON appears as shown in this example: https://i.sstatic.net/BaiPT.png. The object ResourceSortedOrder specifies the order in which items should appear, with checked items having a numerical position while others remain null. Based on this ordering, I am attempting to sort the array/JSON using the following JavaScript code:

for (var i = 0; i < lst.length; i++) {
                  if (lst[i].ResourceSortedOrder != null) {
                   var temp = lst[i];
                  lst.splice(i, 1);
                  lst.splice(temp.ResourceSortedOrder, 0, temp);
                  lst.join();
                }


            }

Although it sorts the data, there is a problem where the first element intended for the 5th position ends up at the 4th position due to the presence of '100srvc resources' above it in the JSON. This leads to inaccurate results as depicted in the following image: https://i.sstatic.net/8Mhza.png How can I achieve the desired outcome instead of what is currently displayed?

Here is the JSON data in string format:

"[{"__type":"BusinessLayer.DTOApptResource","ResourceInClinicID":null,"ResourceInClinicName":null,"ResourceID":"d322a490-60ba-4739-a4ce-7d1de52f1789","ResourceName":"Dr. Maity","ResourceType":"Staff","ResourceRoster":[],"ResourceNotAvailableFrom":"0001-01-01T00:00:00.000Z","ResourceNotAvailableTo":"0001-01-01T00:00:00.000Z","ResourceSortedOrder":5,"ResourceKey":"Staff:d322a490-60ba-4739-a4ce-7d1de52f1789"},{"__type":"BusinessLayer.DTOApptResource","ResourceInClinicID":null,"ResourceInClinicName":null,"ResourceID":"e7217073-0763-4c42-8da0-7b4ce81f886a","ResourceName":"Dr. Shome","ResourceType":"Staff","ResourceRoster":[],"ResourceNotAvailableFrom":"0001-01-01T00:00:00.000Z","ResourceNotAvailableTo":"0001-01-01T00:00:00.000Z","ResourceSortedOrder":1,"ResourceKey":"Staff:e7217073-0763-4c42-8da0-7b4ce81f886a"},{"__type":"BusinessLayer.DTOApptResource","ResourceInClinicID":null,"ResourceInClinicName":null,"ResourceID":"670a9ec7-7502-4710-91d3-1c0dbe3023be","ResourceName":"TEST NEW DSHOME","ResourceType":"Staff","ResourceRoster":[],"ResourceNotAvailableFrom":"0001-01-01T00:00:00.000Z","ResourceNotAvailableTo":"0001-01-01T00:00:00.000Z","ResourceSortedOrder":2,"ResourceKey":"Staff:670a9ec7-7502-4710-91d3-1c0dbe3023be"},{"__type":"BusinessLayer.DTOApptResource","ResourceInClinicID":null,"ResourceInClinicName":null,"ResourceID":null,"ResourceName":null,"ResourceType":null,"ResourceRoster":null,"ResourceNotAvailableFrom":"0001-01-01T00:00:00.000Z","ResourceNotAvailableTo":"0001-01-01T00:00:00.000Z","ResourceSortedOrder":null,"ResourceKey":":"},{"__type":"BusinessLayer.DTOApptResource","ResourceInClinicID":null,"ResourceInClinicName":null,"ResourceID":"","ResourceName":"Hair care","ResourceType":"NonStaff","ResourceRoster":null,"ResourceNotAvailableFrom":"0001-01-01T00:00:00.000Z","ResourceNotAvailableTo":"0001-01-01T00:00:00.000Z","ResourceSortedOrder":null,"ResourceKey":"NonStaff:Hair care"}, ...

javascript arrays json sorting

Answer 1

Answer №1

outcome represents the outcome.
The organize method is not utilized.

var selectedItems = [];
var unselectedItems = [];

list.forEach(function(element){
    if(element.ResourceSortedOrder !== null){
        selectedItems.push(element);
    }else{
        unselectedItems.push(element);
    }
});

var resultArray = [];

selectedItems.forEach(function(element){
    resultArray[element.ResourceSortedOrder] = element;
});

var currentIndex = 0;

unselectedItems.forEach(function(element){   
    while(resultArray[currentIndex]){
        currentIndex ++;
    }
    resultArray[currentIndex] = element;   
});

Answer 2

outcome represents the outcome.
The organize method is not utilized.

var selectedItems = [];
var unselectedItems = [];

list.forEach(function(element){
    if(element.ResourceSortedOrder !== null){
        selectedItems.push(element);
    }else{
        unselectedItems.push(element);
    }
});

var resultArray = [];

selectedItems.forEach(function(element){
    resultArray[element.ResourceSortedOrder] = element;
});

var currentIndex = 0;

unselectedItems.forEach(function(element){   
    while(resultArray[currentIndex]){
        currentIndex ++;
    }
    resultArray[currentIndex] = element;   
});

Answer 3

Answer №2

Try using the code snippet below instead of a traditional for loop to sort the "lst" array.

 lst.sort(function (a, b) {
    var a1 = a.ResourceSortedOrder, b1 = b.ResourceSortedOrder;
    a1 = a1 == null ? 99999 : a1;
    b1 = b1 == null ? 99999 : b1;

    return a1 - b1 ;
});

Answer 4

Try using the code snippet below instead of a traditional for loop to sort the "lst" array.

 lst.sort(function (a, b) {
    var a1 = a.ResourceSortedOrder, b1 = b.ResourceSortedOrder;
    a1 = a1 == null ? 99999 : a1;
    b1 = b1 == null ? 99999 : b1;

    return a1 - b1 ;
});

Answer 5

Answer №3

This snippet of code is designed to arrange items in a list based on the designated "ResourceSortedOrder".

var sortedList = [];
for (var i = 0; i < lst.length; i++) {
    var count = lst.length - sortedList.length;
    var item = null;
    for (var j = 0; j < count; j++) {
        if (lst[j].ResourceSortedOrder == i) {
            item = lst[j];
            break;
        }
    }
    if (item != null) {
        sortedList.push(item);
    }
    else {
        sortedList.push(lst[i]);
    }
}
lst = sortedList;

Answer 6

This snippet of code is designed to arrange items in a list based on the designated "ResourceSortedOrder".

var sortedList = [];
for (var i = 0; i < lst.length; i++) {
    var count = lst.length - sortedList.length;
    var item = null;
    for (var j = 0; j < count; j++) {
        if (lst[j].ResourceSortedOrder == i) {
            item = lst[j];
            break;
        }
    }
    if (item != null) {
        sortedList.push(item);
    }
    else {
        sortedList.push(lst[i]);
    }
}
lst = sortedList;

organize an array or JSON based on a numeric value or object in JavaScript

Answer №1

Answer №2

Answer №3

Similar questions

having difficulty grasping the variable's scope within this code

Processing JSON Serialization from Controller to AJAX Response

Embedded Javascript fails to function following an async postback triggered by an UpdatePanel

Vue3 - Implementing a seamless communication channel between two child components

Exploring X3DOM nodes using d3.js

What advantages does Protractor offer for non-angular applications?

Why does my function only execute once? I am attempting to run the function multiple times, but it seems to only run once before the previous invocation is completed

Exploring methods for testing an HTML page that utilizes jQuery for DOM manipulations

How to Use $scope within a Function in AngularJS

The server is currently unable to process my JSON object

Issue with NextAuth v4 Credentials Provider failing to provide an Id when requested

What is the best way to find the elements in one array that are not present in another array?

There was an issue with the Discord.js (v12) Giveaway Command that resulted in an error stating "Error: Cannot read property 'hasPermission' of undefined"

Finding the smallest value within a collection of JSON objects in an array

Updating a property of a JavaScript class using a callback function inside the class method after an AJAX request

Attempting to implement real-time AJAX search feature in the sidebar

I'm curious as to why IPC messages from one menu item in Electron can successfully reach my window, but when sent from a different menu item, they do not seem to

Enabling the submit button only when text is entered in the text fields using jQuery

Searching with regex to find keys in an object structured like JSON

Dynamic Components in Vue.js Router