GROUP_CONCAT - mySql

Posts   
 
    
hcaldeira
User
Posts: 16
Joined: 24-Mar-2009
# Posted on: 28-Sep-2011 17:55:14   

How to use function GROUP_CONCAT in mySql provider?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 28-Sep-2011 18:08:50   
hcaldeira
User
Posts: 16
Joined: 24-Mar-2009
# Posted on: 28-Sep-2011 18:45:12   

Thanks Walaa its easy and works simple_smile

here is my solution: fields[1].ExpressionToApply = new DbFunctionCall("CAST(GROUP_CONCAT({0} SEPARATOR '|') as CHAR)", new object[] { WaveHasOptionFields.WaveOptionId });

Cheers