How to convert a List of Structures to Text (similar to String_Join)?

Back to Forums

Mahmoud Mohamed

Question

Logic

Hi everyone,

I have a Structure like this:

MyStructure- Value (Text)

On my screen, I have a List of MyStructure.

I want to convert the list into a single Text value, similar to String_Join().

For example:

List:- Apple- Orange- Banana

Expected result:

Apple, Orange, Banana

Is there a built-in function in OutSystems to do this, or what's the recommended approach?

I'd prefer to avoid using a For Each loop if possible.

Thanks!

05 Jul

Sherif El-Habibi

Champion

Hi @Mahmoud Mohamed,

You can use BuildSafe_InClauseTextList.

For example, in the screenshot, I have a variable called Var, which is a list strucutre. Another variable In1 is of type TextLiteral List. You can obtain this type by consuming the BuildSafe_InClauseTextList action from the Sanitization.

Next, use ListAppendAll to append your list data into the TextLiteral List (avoiding the loop as you mentioned). This converts the values into a safely formatted, comma-separated list.

Last 4 Screenshots I launched the Debugger for you to see the results, the action BuildSafe_InClauseTextList will add N' but you can use Replace to avoid this getting the results you want.

Also attached the OML for you.