Concatenating operations from a Method


(Judy Poling) #1

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!


(Bruce Ordway) #2

Check out this thread…


(Judy Poling) #3

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?


(Jose C Gomez) #4

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.


(Bruce Ordway) #5

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