I am trying to concatenate multiple rows to a single field in a query and am wondering how to do it in a BAQ. Below are a couple of different ways I can do it in a SQL query. Example 1: Select distinct ST2.JobNum, substring( ( Select ‘,’+ ST1.OpCode AS [text()] From Erp.JobOper ST1 Where ST…

Check out this thread. There is an example BAQ that you can download to show you how it works. [image] BAQ: Calculated Field Concatenate Rows to single field Experts' Corner You can use one of these methods to do it I’ve done …

Great! Thanks so much. I will work with that. I don’t know how I missed that in my search. Ross

One of our IT guys created a function under the Aggregate functions in SQL DB called dbo.Agregate. When grouping, we call this function in our BAQ calculated field : dbo.Agregate(field to concatenate) same as if we would do a sum(field). The result is the calculated field having all the grouped…

[image] Hogardy: One of our IT guys created a function under the Aggregate functions in SQL DB called dbo.Agregate. I would love it if you have any more info on how to do that. That would definitely be handy.

USE [Pilot-DB] GO /****** Object: UserDefinedAggregate [dbo].[Concatenate] ******/ CREATE AGGREGATE [dbo].[Concatenate] (@value nvarchar ) RETURNS nvarchar EXTERNAL NAME [Polymos.SQL.StringUtils].[Concatenate] GO In the BAQ I call dbo.Concatenate(field) The result is comma seperated info…

And a look forward to SQL 2017… [image] STRING_AGG (Transact-SQL) - SQL Server STRING_AGG (Transact-SQL) Mark W.

so that’s why that doesn’t work! I saw that and was trying it to no avail. Good thing my IT guy is getting documentation now to upgrade to 2017.

[image] Banderson: Good thing my IT guy is getting documentation now to upgrade to 2017. But wait for Epicor to certify first!

[image] Hogardy: USE [Pilot-DB] GO /****** Object: UserDefinedAggregate [dbo].[Concatenate] ******/ CREATE AGGREGATE [dbo].[Concatenate] (@value nvarchar) RETURNSnvarchar EXTERNAL NAME [Polymos.SQL.StringUtils].[Concatenate] GO In the BAQ I call dbo.Concatenate(field) The result is…

Now I am totally confused because according to the 10.2 installation guide it says: “Windows Server 2012 R2 with SQL Server 2014, 2016 or 2017.” No mention of Server 2016 which I thought was certified for 10.1

BAQ Concatenate Rows Columns to Field

Epicor ERP 10

Banderson (Brandon Anderson) April 27, 2018, 2:49pm 2

Check out this thread. There is an example BAQ that you can download to show you how it works.

Topic		Replies	Views
What's going on here? Epicor ERP 10 e10 , baq	10	851	October 26, 2021
BAQ: Calculated Field Concatenate Rows to single field Experts' Corner	132	65159	June 14, 2023
Concatenate OP's in order of OP Sequence Epicor ERP 10 baq	9	881	January 30, 2024
BAQ - Concatenate results from subquery into one field Epicor ERP 10 baq	7	2968	August 30, 2023
Combine Calculated felds into one row via BAQ's Epicor ERP 10 baq	3	1750	December 30, 2022

BAQ Concatenate Rows Columns to Field

Related topics