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…
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.
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