Could someone chime in on this one ?
Below you find my code, I've tried to add clear comments.
I've tried different approaches, without luck but must be missing something in my first attempts to try this function.
Also attached is a screenshot from dataviewer and Context.
While (
[
~i = 1 ; //index or counter
~trshld = SYSid_zzk_ArCo~kunstenaar ; //in this particular case 119, just a hard coded primary key derived from a custom function
~value = "" ; //declaring this var for later use
~id = "" //declaring this var for later use
] ;
~id = ~trshld ; //if ~id equals to the ~trshld, the loop must stop
[
~id = GetNthRecord ( SYS~::__id ; ~i ) ; //Set ~id based on ~i, should be replaced when looping.
~value = GetNthRecord ( SYS~::Value ; ~i ) ; //Set ~value based on ~i, should be replaced when looping
~i = ~i + 1 //raise index so loop looks for next record
] ;
~value //output
)