Hi team,
Iam building a logic where i have two lists as listed below, now i want to check data[1] i.e, wifi Router Demand value 500 with all (5 items)count values in Items[1] . and same data[2] with items[2] with all 5 count values in items[2] and return the sparepart Names that are less than demand value.
1. data: [product=Wi-Fi Router, Demand=500, productid=]; [product=Wi-Fi Extender, Demand=7, productid=]
2.items:{
{{Sparepart: "Wi-Fi Module", count: 100, productid: 1},
{Sparepart: "Antenna", count: 100, productid: 1},
{Sparepart: "Power Supply Unit", count: 100, productid: 1},
{Sparepart: "Ethernet Port", count: 100, productid: 1},
{Sparepart: "CPU Chip", count: 100, productid: 1}
},
{
{Sparepart: "Wi-Fi Extender Module", count: 20, productid: 2},
{Sparepart: "Extension Antenna", count: 30, productid: 2},
{Sparepart: "Power Adapter", count: 15, productid: 2},
{Sparepart: "Ethernet Cable", count: 25, productid: 2},
{Sparepart: "Signal Booster", count: 10, productid: 2}
}
i tried with the following, but for Demand i used a flag variable at last. i am unable to understand who to achieve this. please help me in solving this.
a!localVariables( local!flag:1, local!data: ri!DemandProduct, local!items: a!forEach( items: local!data, expression: rule!SCM_Sparepartsdata(local!data[fv!index].product) ), a!forEach( items: local!items, expression: a!forEach( items: local!items[fv!index], expression: {a!forEach( items:{ fv!item.count}, /*expression: if(fv!item>local!data[1].Demand,fv!item ," ")*/ expression:if( fv!item < local!data[local!flag].Demand, fv!item, " " ), ), } ) ) )
Discussion posts and replies are publicly visible
Hey Aryan,
i want to show the Spare parts and Demand value respectively in a Editable grid as shown below, i was able to get the Item names but the QTY here refer to Demand value. but here iam getting 1st items from the list 294 demand value for every row
aryan said:What's the problem?
The comment you're replying to is just a spambot.