Hi! Is it possible to concatenate these values after group by?
I want the output to be “Order Fulfillment, Customer Experience” since they just belong to a single activity.
Answer
Generic Inquiry Concatenate Field Values in Group By
Best answer by dcomerford
I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
+15I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
Dermot Comerford
I dont believe you can do ths using the Standard GI functionality as there is not an Aggreate Option for Concat on a string value. Your other option would be to create a SQL view to do this and then use this as a DAC for your Generic Inquiry.
https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/
Thank you so much!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.