Solved

Generic Inquiry Concatenate Field Values in Group By

  • 26 September 2023
  • 3 replies
  • 91 views
J
Rank
Userlevel 1
Badge

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.

icon

Best answer by dcomerford 26 September 2023, 11:20

View original

3 replies

J
Rank
Userlevel 1
Badge

Here’s my GI:

1 Attachment
dcomerford
Rank
Userlevel 7
Badge +12

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/

Dermot Comerford
J
Rank
Userlevel 1
Badge

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!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved