Hi,

I searched for using group_concat in outsystems.I tried STUFF as well, but its not working.

My query is simple "

SyntaxEditor Code Snippet

select group_concat({Products}.[Id]) from {Products}

". So how can i achieve it, can anyone explain me plz...

Hello Thanigai,

Are you using MySql?
Because if you are using SQL Server (the most common database for OutSystems, and the one used on all personals), it does not have this clause (that would not work as it would require the GROUP BY, anyway).

And STUFF in SQL Server does not do the same thing.

So, what are you trying to accomplish?

Cheers.



P.S. If you are trying to concatenate the IDs in an SQL database, please, take a look here:

https://stackoverflow.com/questions/17591490/how-to-make-a-query-with-group-concat-in-sql-server

Cheers.