how to exclude row after checking its data

Question

Question

OHAD Saa · Dec 14, 2023

#InterSystems IRIS

This question originally appeared in the comments of the post: The Art of Mapping Globals to Classes (5 of 3)

Hey

I need to know how to exclude row after checking his data, for example:

^global(1,2)=a*b

^global(1,3)=a*c

if $P(^global(key1,key2),"*",2)=c Q

how can i do this?

thanks

Discussion (3)1

Log in or sign up to continue

score 0 · Answer 1 · 2023-12-15T01:40:13-05:00

No t100% sure what you are after but if you just want to generalize the if then something like this will do:

set key1=1
set key2=2

if ($piece($get(^global(@key1,@key2)),"*",2)=c) { quit }

score 0 · Answer 2 · 2023-12-15T03:10:33-05:00

I think we need more context but in case you were iterating the global you could do this:

Set key2=""
For{
    Set key2=$O(^global(key1,key2))
    Quit:key2=""
    Continue:($G(^global(key1,key2))=c) // will skip this node and continue with next
    ...
    
}

If there isn't an iteration you could do:

^global(1,2)=a*b

^global(1,3)=a*c

Q:($P(^global(key1,key2),"*",2)=c)

score 0 · Answer 3 · 2023-12-17T05:01:58-05:00

thank you for your answer originaly I wrote the question in the page related to mapping a global to SQL and that's where I want to do this filter. where can I write the code for it? how can I refer to a pice inside the global while mapping? thanks