Hi all,

im trying to use the BuildSafe_InClauseTextList . but seems it is requiring of type TextLiteral.

i need to dynamically add on a list of texts into my IN clause,

for below snippet, i created a TextLiteral List, and used ListAppendAll, element [0] = "SomeText",  but i cant add text to it as per instruction below. 

it will prompt error "TextLiteral" data type required instead of text"

ListA[0].Value = "John Doe"
ListA[1].Value = "Mary O'Hara"
BuildSafe_InClauseTextList(ListA) = "'John Doe','Mary O''Hara'"

links below are my references.

https://success.outsystems.com/Documentation/Best_Practices/Development/Building_Dynamic_SQL_Statements_the_Right_Way

https://success.outsystems.com/Documentation/11/Reference/OutSystems_APIs/Sanitization_API?_gl=1*1qybgxe*_ga*MTQ4MzgxOTcuMTY0MDU3Nzk1NQ..*_ga_ZD4DTMHWR2*MTY1NDIzMTU0Ny42MS4xLjE2NTQyMzQ1MTYuNjA.#Structure_TextLiteral