Group_Concat
Question

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...

mvp_badge
MVP

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.



mvp_badge
MVP

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.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.