Slurp all fields' values into one variable from found set?
Is there a simple one-step way to slurp up a field's value for an entire found set into one variable? Without a loop, that is.
Say you search your user table for a subset matching a criteria, is there a way to set a variable to each UserID in that found set? (I want the list of UserIDs so that I can populate records in another table a bit later in the script.)
On a related note, do dynamic value lists require that you use them from a specific context (i.e. one of the tables used in the definition of that list, either as a basis for the layout or some other context involving one or other of the tables)? I was trying to use an already defined value list from our system using:
Set variable [ $List ; Value:ValueListItems (get(filename); ListName)]
But my variable is coming back empty.