AnsweredAssumed Answered

Slurp all fields' values into one variable from found set?

Question asked by disabled_JustinClose on Feb 24, 2012
Latest reply on Feb 24, 2012 by philmodjunk

Title

Slurp all fields' values into one variable from found set?

Post

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.

 

Thanks,

-J

Outcomes