I am trying to concatenate the first two characters from each remaining operation on a job. Example: 10 Shear 20 Compound 30 Form What I would like to see in my BAQ is this: SH/CO/FO Can anyone tell me how this could be done? Thank you in advance for your time!

Check out this thread… [image] BAQ: Calculated Field Concatenate Rows to single field Experts' Corner Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the P…

I tried to import CustOrder.baq but I am getting the following error: Can’t import query definition from version latter than current: 3.1.500.0 Query import finished with error(s) Anyway I can get around this?

You can’t if you are in an older version of EPicor. But if you follow the thread you should be able to reconstruct it without importing it.

[image] jpol: import finished with error(s) Anyway I can get around this You could try downloading this PDF and building manually. Includes screen shots for the Inner subQuery and the Top Level subquery https://drive.google.com/file/d/1c-vNSvdtgUYREz-JjYan3Lof0xLxufJw/view?usp=sharing

Concatenating operations from a Method

Epicor ERP 10

bordway (Bruce Ordway) March 12, 2018, 5:59pm 2

Check out this thread…

Topic		Replies	Views
Concatenate OP's in order of OP Sequence Epicor ERP 10 baq	9	881	January 30, 2024
BAQ Concatenate Rows Columns to Field Epicor ERP 10	14	10641	April 30, 2018
[SOLVED] Group multiple results into one line Epicor ERP 10	7	9044	April 26, 2023
What's going on here? Epicor ERP 10 e10 , baq	10	851	October 26, 2021
Concatenate field sorting Epicor ERP 10 baq	1	438	February 7, 2020

Concatenating operations from a Method

Related topics