Hi everyone,

I am using the STRING_AGG function within a CTE and it's working just fine (line 11 of the image below).

However, I would like to apply an order by clause do the Agg function like i wrote in line 10.

When I run que query in SQL Server it works just fine and I get the expected output, however when I test the same exact query in service studio I get an error and the same happens when the application tries to run the query.

I am not sure if has something to do with outsystems built in database engine that utilizes a different syntax for this purpose or if has something to do with database versions also possibly affecting the syntax.

I also tried to run SELECT STRING_AGG ({CONTRAPARTES}.[Nome], ', ' order by {CONTRAPARTES}.[Nome]) but also received an error.

If anyone has any idea on how to apply the ORDER BY clause the the STRING_AGG function in outsystems or has any other alternative that would give me the same expected output I would really appreciate it.

Thank you everyone!