Skip to main content
Answer

BQL: Aggregate Strings

  • October 17, 2023
  • 1 reply
  • 167 views
S

Does a Fluent BQL equivalent exist for the STRING_AGG function in SQL Server?

 

I am writing a query over a one-to-many relationship and would like to see a string column from the `many` table concatenated with commas.  Similar to how Customization Projects can display multiple Screen Names in a single cell.

 

Does any one know the best practice for achieving this?

Best answer by RohitRattan88

@skelly 

I am not aware of such BQL function but you could get your list using BQL and then use JoinToString(",") c# function to join those.

1 reply

RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • RohitRattan88
  • Acumatica Moderator
  • Answer
  • October 17, 2023

@skelly 

I am not aware of such BQL function but you could get your list using BQL and then use JoinToString(",") c# function to join those.

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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