Group Reference Designators in a BAQ

Epicor ERP 10
1

I have a BOM Dashboard that allows the user to compare two different revisions. Same query side by side in a dashboard. Works great but I need to pull in the reference designators for each part material which means I will have the same material part number multiple times for each reference designator. Anyone know if there is a way to group the reference designators, so they show in one field separated by a tilde?

2

Are you really still on 10.1? I can’t remember when they added this feature. Compare anything to anything.

image
image1377×584 26.8 KB

3

If your sql server is 2017 or later, take a look at STRING_AGG()

4

And don’t forget to set your SQL Server compatibility level to 2017 or higher as appropriate.