Aggregate function GROUP_CONCAT for AOR

SuiteCRM Forum - English Language Developer Collaboration
1

I’m not sure if this is the right place for my request … but I’ll give it a try :slight_smile:

For a new report (AOR) I have the requirement to display aggregated row values (strings) ​​separated by commas.
A possible approach would be an additional AOR aggregate function “GROUP_CONCAT ()”.

My questions to you:

  • Is there already a solution for this in SuiteCRM/AOR
  • if not … would it be desirable to provide this function for everyone?

Thanks, Tom

2

In order to get to the affected code point quickly, I wanted to provoke an exception by adding the value “GROUP_CONCAT” to “aor_function_list”. Instead of the exception, however, I got exactly the result I wanted. Problem solved - I’m just fascinated!

1 Like