Hello Quadir.K

You could convert your aggregate to SQL and use the BuildSafe_InClauseIntegerList and BuildSafe_InClauseTextList action from sanitization module. 

Please refer to this link

Hope it helps you.

Regards,

Pavan R

You can use the BuildSafe_InClauseTextList from the  Sanitization extension.

First, create a string from the data you need using this action:

create an input parameter in your advanced SQL and assign the result from the previous Step.
Don't froget to put the 'EXPAND INLINE' on YES or it will not work.

Hi,

i created a Forge component that shows how to apply a facet filter using an advanced sql in clause query. https://www.outsystems.com/forge/component-overview/15145/pattern-sql-patterns

Stefan

Hi,

Please check the below link:

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

Inside the manage dependencies window you will get sanitization extension there you will find built in function for comma separated list.

Regards,

Anees

Thank you All