Solved

BQL: Aggregate Strings

  • 17 October 2023
  • 1 reply
  • 58 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?

icon

Best answer by RohitRattan88 17 October 2023, 17:48

View original

1 reply

RohitRattan88
Rank
Userlevel 7
Badge +4

@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.

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