Get Data from global node after using $Query

Question

Question

Mark OReilly · Aug 24, 2022

#Globals #InterSystems IRIS for Health

I am using $Query to loop through a global.

When I use $GET to get the data all we get back is the global name.

How do you get the value of the global after you have looped.

Below is my example in terminal.

Thank you in advance

Set node = $Query(^FromExtraMed(""))

w node
^FromExtraMed("A02",9220)

If i try w $GET(node) it returns

^FromExtraMed("A02",9220)

If i had this hardcoded it would have got the value

w $GET(^FromExtraMed("A02",9220))
0,66340,2120

I have already read the documentation and it is not clear. Can someone advise?

Product version: IRIS 2022.1

Discussion (5)2

Log in or sign up to continue

Eduard Lebedyuk · Aug 24, 2022

Check the docs, specifically the target argument.

1 0

Robert Cemper · Aug 24, 2022

2 mistakes:
#1^$get(node) delivers the content of variable node
but you would expect the result of $get(@node) using node as global reference

#2) the better way is to use the implicit GET
Set node = $Query(^FromExtraMed(""),1,value)
write value

1 0

score 0 · Answer 1 · 2022-08-24T08:52:48-04:00

Thanks didn't see that

have changed to the below which works from your answer

Set node = $Query(^FromExtraMed(""),1,nodevalue)

while (node '="")
{
write nodevalue,!

Set node = $Query(@node,1,nodevalue)

}

score 0 · Answer 2 · 2022-08-24T08:47:37-04:00

Udo Leimberger · Aug 24, 2022

As Eduard mentioned — use the optional target parameter to get the value .. or use $O

0 0

score 0 · Answer 3 · 2022-08-25T21:47:53-04:00

Antoni Peña · Aug 25, 2022

Hi,

You can try:

write $get(@node)

0,66340,2120

Regards, Toni Peña

0 0