Compare and get the ItemName

Question

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,
 " "
 ),
 
 
 ),
 
 }
 )
 )
)

aryan · Accepted Answer

As fas as I understand, is this what you're looking for? a!forEach(
 items: local!data,
 expression: a!localVariables(
 local!demand: fv!item.demand,
 local!item: local!items[fv!index],
 a!map(
 result: reject(
 fn!isnull,
 a!forEach(
 items: local!item,
 expression: if(
 tointeger(local!demand) > tointeger(fv!item.count),
 fv!item,
 null()
 )
 )
 )
 )
 )
 )