Splitting out array into multiple arrays based on id

Question

I have the following JSON sample:

[
    {
        "id": "116621",
        "field": "list18",
        "line": 0,
        "value": "6",
        "changeOrder": 5
    },
    {
        "id": "116621",
        "field": "list16",
        "line": 0,
        "value": "47",
        "changeOrder": 4
    },
    {
        "id": "116621",
        "field": "list17",
        "line": 0,
        "value": "3",
        "changeOrder": 2
    },
    {
        "id": "116622",
        "field": "list16",
        "line": 1,
        "value": "6",
        "changeOrder": 3
    },
    {
        "id": "116623",
        "field": "list18",
        "line": 2,
        "value": "11",
        "changeOrder": 6
    },
    {
        "id": "116623",
        "field": "list16",
        "line": 2,
        "value": "5",
        "changeOrder": 1
    }
]

I am trying to run a process that opens a record (based off the id), update values and then saves it.

However instead of running through each item and duplicating open the same record, it would save time by opening the same id record once, running through each item, and then saving it.

So what i need to do is to return the data like this so that it only opens the record once to update. For instance if it is id "116621" then it would group all the id "116621" so i can update each value that is returned - like this:

[
    {
        "id": "116621",
        "field": "list18",
        "line": 0,
        "value": "6",
        "changeOrder": 5
    },
    {
        "id": "116621",
        "field": "list16",
        "line": 0,
        "value": "47",
        "changeOrder": 4
    },
    {
        "id": "116621",
        "field": "list17",
        "line": 0,
        "value": "3",
        "changeOrder": 2
    }
]

I wont know how many are in the array, nor what ID's they will be. All i know is that it will be a sorted array as I have already coded that bit in.

Any help to get a function to return the single array would really be helpful.

Thank you

Does this answer your question? Javascript - extract items from array based on id filter to create 2 arrays — Krzysztof Krzeszewski
– Krzysztof Krzeszewski, Commented Oct 15, 2021 at 9:08
@KrzysztofKrzeszewski unfortunately not, I don't know what the array id values are so I cant run a loop checking they match. — Andrew
– Andrew, Commented Oct 15, 2021 at 9:16

J_K · Accepted Answer · 2021-10-15 10:49:21Z

Does this help? You can write a function to filter your data by an id(you can make it dynamic since you don't know what it will be) and do the changes only on the filtered array. You can then return either the entire data or the filtered array.

let data = [
    {
        "id": "116621",
        "field": "list18",
        "line": 0,
        "value": "6",
        "changeOrder": 5
    },
    {
        "id": "116621",
        "field": "list16",
        "line": 0,
        "value": "47",
        "changeOrder": 4
    },
    {
        "id": "116621",
        "field": "list17",
        "line": 0,
        "value": "3",
        "changeOrder": 2
    },
    {
        "id": "116622",
        "field": "list16",
        "line": 1,
        "value": "6",
        "changeOrder": 3
    },
    {
        "id": "116623",
        "field": "list18",
        "line": 2,
        "value": "11",
        "changeOrder": 6
    },
    {
        "id": "116623",
        "field": "list16",
        "line": 2,
        "value": "5",
        "changeOrder": 1
    }
]
function filteredData(data, value){
  let filtered =  data.filter(obj=> obj.id === value)
  //do what you want with filtered data
  filtered.forEach(obj=> obj.value = 0)
  //return data
   return filtered
}
console.log(filteredData(data, "116621"))

Terry Lennox · Accepted Answer · 2021-10-15 11:05:11Z

You could adopt a generic approach, specifying filter() and update() functions.

The updater function would then be applied to any matching elements, in this example we'll increment the changeOrder of any matching elements.

const input = [ { "id": "116621", "field": "list18", "line": 0, "value": "6", "changeOrder": 5 }, { "id": "116621", "field": "list16", "line": 0, "value": "47", "changeOrder": 4 }, { "id": "116621", "field": "list17", "line": 0, "value": "3", "changeOrder": 2 }, { "id": "116622", "field": "list16", "line": 1, "value": "6", "changeOrder": 3 }, { "id": "116623", "field": "list18", "line": 2, "value": "11", "changeOrder": 6 }, { "id": "116623", "field": "list16", "line": 2, "value": "5", "changeOrder": 1 } ];
 
function updateArray(arr, filter, updater) {
    arr.filter(filter).forEach(updater);
    return arr;
}

const targetId = '116621';
const filter = el => el.id === targetId;
const updater = el => el.changeOrder++;

console.log('Updated:', updateArray(input, filter, updater));

.as-console-wrapper { max-height: 100% !important; top: 0; }

Collectives™ on Stack Overflow

Splitting out array into multiple arrays based on id

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related