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
You can use the a!update() function, something like this:
a!localVariables( local!query1Result: a!map(id: 54, class: "B", owner: "xyz"), local!query2Result: a!map(id: 54, owner: "abc"), a!update( local!query1Result, "owner", local!query2Result.owner ) )
if query1 has list, like
id :54, class: b, owner :"xyz
id:54, class:a, owner:"pqr
in this case i have to update id=54 and class : b owner then how can i write