I have created a BAQ to list multiple PO Numbers in one Row, separated by a comma as follows: [image] I created this as follows: [image] [image] [image] SQL Query Phrase: select [OrderDtl].[OrderNum] as [OrderDtl_OrderNum], [OrderDtl].[PartNum] as [OrderDtl_PartNum], [OrderDtl].[LineDe…

I figured it out! I had to add a SubQuery Criteria (not Table Criteria), and I had to order it before the “FOR XML PATH” expression. Now it’s working perfectly. Thanks for the help! [image]

Concatenate multiple rows into one row, with criteria

Epicor ERP 10

Banderson (Brandon Anderson) January 8, 2019, 3:08pm 6

Check out this thread. @josecgomez posted and example BAQ in there that you can look at.

1 Like

Topic		Replies	Views
What's going on here? Epicor ERP 10 e10 , baq	10	729	October 26, 2021
BAQ - Concatenate results from subquery into one field Epicor ERP 10 baq	7	2369	August 30, 2023
Concatenate OP's in order of OP Sequence Epicor ERP 10 baq	9	756	January 30, 2024
BAQ Concatenate Rows Columns to Field Epicor ERP 10	14	9840	April 30, 2018
BAQ incorrect syntax near 'FOR' Epicor ERP 10 e10	10	2416	December 20, 2022

Concatenate multiple rows into one row, with criteria

Related Topics