Concatenating operations from a Method

(Judy Poling) #1

I am trying to concatenate the first two characters from each remaining operation on a job.

10 Shear
20 Compound
30 Form

What I would like to see in my BAQ is this:

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