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
Discussion posts and replies are publicly visible
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", "" ), ) ) )