update

Question

i'll get list of data from one query, to that query data i have to map few fields value 
 ex query1 gives : 
 id :54, class: B, owner :xyz 
 id:54, class: A, owner :test 
 from second query from another table will get 
 id:54, owner :abc 
 this second query owner data needs to update/show in query1 how can i achieve this 
 update for 
 id:54, class:A , owner: abc

balti · Answer

for refrence -> a!localVariables(
 local!a: {
 a!map(id: 2, class: "A", owner: "aman_updated"),
 a!map(id: 2, class: "B", owner: "nasir")
 },
 local!b: { a!map(id: 2, owner: "aman_update") },
 a!forEach(
 items: local!b,
 expression: a!map(
 id: fv!item.id,
 class: index(
 local!a,
 index(
 wherecontains(fv!item.id, local!a.id),
 1,
 ""
 ),
 "class",
 ""
 ),
 owner: index(
 local!a,
 index(
 wherecontains(fv!item.id, local!a.id),
 1,
 ""
 ),
 "owner",
 ""
 ),
 
 )
 )
)

update

Top Replies