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, abc, class: B, owner :xyz
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
Discussion posts and replies are publicly visible
a!localVariables( local!query1Result: { a!map(id: 54, class: "B", owner: "xyz"), a!map(id: 55, class: "C", owner: "abc"), a!map(id: 56, class: "D", owner: "mno"), a!map(id: 57, class: "E", owner: "ghi") }, local!query2Result: { a!map(id: 54, owner: "help"), a!map(id: 57, class: "F") }, local!getIndex: cast( typeof({ 1 }), index(local!query2Result, "id", null) ), a!forEach( items: local!query1Result, expression: if( contains( local!getIndex, tointeger(index(fv!item, "id", null)), ), a!localVariables( local!data:index( local!query2Result, wherecontains( tointeger(index(fv!item, "id", null)), local!getIndex ) ), local!keys: a!keys( cast(typeof(a!map()), index( local!query2Result, wherecontains( tointeger(index(fv!item, "id", null)), local!getIndex ) ) ) ), a!update( data: local!data, index: local!keys, value:touniformstring(index( fv!item, {local!keys} )) ) ), fv!item ) ) )