Group json objects in an array based on unique id

Question

For example this the json which i get.Json group this

var data = [{
        orderid: 1,
        ordername:ordername1,
        productcode: 1,
        productname: product1,
        productquantity: 10
    },
    {
        orderid: 2,
        ordername:ordername2,
        productcode: 2,
        productname: product2,
        productquantity: 11
    },
    {
        orderid: 1,
        ordername:ordername3,
        productcode: 3,
        productname: product3,
        productquantiy: 45
    }
]

Expected output

[
{
    orderid: 1,
    ordername:ordername1,
    products: [
    {
        productcode: 1,
        productname: product1,
        productquantity: 10
    },
    {
        productcode: 3,
        productname: product3,
        productquantity: 45
    }]
},
{
    orderid: 2,
    ordername:ordername2,
    products: [
    {
        productid: 2,
        productname: product2,
        productquantity: 11
    }]
}]

How to do this in react native.How to group this based on orderid.Now i have added ordername also so how to include that also

I'd use lodash for this

MattE
– MattE

2019-10-01 16:45:02 +00:00
Commented Oct 1, 2019 at 16:45 — MattE
– MattE, Commented Oct 1, 2019 at 16:45
can you give an example

Annaz
– Annaz

2019-10-01 16:46:25 +00:00
Commented Oct 1, 2019 at 16:46 — Annaz
– Annaz, Commented Oct 1, 2019 at 16:46

Medet Tleukabiluly · Accepted Answer · 2019-10-02 03:10:37Z

Easily achievable using Array.reduce

var data = [{
    orderid: 1,
    ordername: 'ordername1',
    productcode: 1,
    productname: 'product1',
    productquantity: 10
  },
  {
    orderid: 2,
    ordername: 'ordername2',
    productcode: 2,
    productname: 'product2',
    productquantity: 11
  },
  {
    orderid: 1,
    ordername: 'ordername3',
    productcode: 3,
    productname: 'product3',
    productquantity: 45
  }
];


// reduce iterates over each item, using accumulator
var orderedData = data.reduce((acc, next) => {

  // reusable product var
  var nextProduct = {
    productcode: next.productcode,
    productname: next.productname,
    productquantiy: next.productquantity
  }

  // find similar orders, and join them
  var exist = acc.find(v => v.orderid === next.orderid);
  if (exist) {

    // order exists, update its products
    exist.products.push(nextProduct);
  } else {

    // create new order
    acc.push({
      orderid: next.orderid,
      ordername: next.ordername,
      products: [nextProduct]
    })
  }
  return acc
}, [])

console.log(orderedData)

Thakur Karthik · Accepted Answer · 2019-10-02 04:32:59Z

0

Tried implementing generically

function group(data,property,extra=[]){
	let output=[]
	data.forEach(item=>{
		const indexOfItem=output.length>0 ?output.findIndex(outputItem=>outputItem[property]===item[property]):-1
		if(indexOfItem===-1){
            let tempOutput={}
            extra.forEach(key=>{
             if(item[key]){tempOutput[key]=item[key]}
            })
			let {[property]:propertyValue,...rest}=item;
			output.push({[property]:propertyValue,...tempOutput,products:[{...rest}]})
		}
		else{
			let {[property]:propertyValue,...rest}=item;
			output[indexOfItem].products.push({...rest})
		}
	})
	return output
}

var data = [{
        orderid: 1,
        ordername:'order1',
        productcode: 1,
        productname: "product1",
        productquantity: 10
    },
    {
        orderid: 2,
        ordername:'order2',
        productcode: 2,
        productname: "product2",
        productquantity: 11
    },
    {
        orderid: 1,
        ordername:'order3',
        productcode: 3,
        productname: "product3",
        productquantiy: 45
    }
]

console.log(group(data,'orderid',['ordername']))
//console.log(group(data,'productcode'))

Now you can use group(data,"property name")

edited Oct 2, 2019 at 4:32

answered Oct 1, 2019 at 17:59

Thakur Karthik

3,6483 gold badges17 silver badges27 bronze badges

2 Comments

Annaz Over a year ago

@ Thakur Karthik now i have added ordername also so how do i get that

Thakur Karthik Over a year ago

@Annaz added additional modification,now you can pass the extra variables.But remember they must also be unique like id or else they will be overriden by later values.Try it out!

Collectives™ on Stack Overflow

Group json objects in an array based on unique id

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related