AnsweredAssumed Answered

Group_concat ExecuteSql

Question asked by rivet on Nov 16, 2018
Latest reply on Nov 19, 2018 by rivet

Is there some way to achieve the following results with ExecuteSql. For each request record there is a id_claim and a city, I would like to know all cities for that claim id.

 

Query

SELECT id_claim, GROUP_CONCAT( city SEPARATOR ', ')
FROM request 
GROUP BY id_claim

 

Result

id_claim, cities
101, toronto, montreal
102, vancouver, toronto, new york
103, montreal
104, toronto, calgary
105, calgary

Outcomes