CoreBOSBB
Concatenate values from related list - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Support (https://discussions.corebos.org/forumdisplay.php?fid=17)
+--- Forum: User Support (https://discussions.corebos.org/forumdisplay.php?fid=6)
+--- Thread: Concatenate values from related list (/showthread.php?tid=2016)



Concatenate values from related list - radu - 11-12-2020

Hello,

Is it possible to concatenate all the values in a specific field from all the relations in a 1-many relationship and save them in a field? for example I want to concatenate all the subjects of the task projects related to a certain project in it's description textbox. I tried to use the aggregation workflow function but it doesn't seem to do that.
Thanks


RE: Concatenate values from related list - joebordes - 11-12-2020

Hi
Yes, aggregation is exactly what you need. You have to use the group_concat aggregation


RE: Concatenate values from related list - radu - 11-12-2020

It works. Thanks! I did not know about that operation in the function.


RE: Concatenate values from related list - joebordes - 11-12-2020

:-)