# BAQ to show the FIRST Operation on a Job

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-12-06 16:41 UTC
**Views:** 3940
**Replies:** 12
**URL:** https://www.epiusers.help/t/baq-to-show-the-first-operation-on-a-job/36518

---

## Post #1 by @astrys

We have Operations set up so that the production manager can assign jobs to pickers based on the first operation.

I am trying to write a BAQ that will return the first Operation in a job.
Does anyone know what the code might look like to show only the first OpSeq in each job?

This is just a "catch-all" for jobs that do not start with OpSeq 10.

---

## Post #2 by @irus26

<img src="/uploads/default/original/1X/9da91ee9283f0b701f58ad4275fbf8b94fd24707.png" width="690" height="91">

<img src="/uploads/default/original/1X/ce7d3d9e4c86350f4b993adf62ce7ad7c1033ce8.png" width="690" height="419">

Does that help ?

Johnny

---

## Post #3 by @astrys

Unfortunately, no.
I might be missing something though.

<img src="/uploads/default/original/1X/8a9c7f6439e60bb6dba9735fd01ce9f3be4dbd72.png" width="690" height="340">

---

## Post #4 by @irus26

Do not use Group By for the calculated field

---

## Post #5 by @astrys

I don't think that is working.
I added the Calculated Field and the Syntax was OK, but it is just showing all the OprSeq's.

<img src="/uploads/default/original/1X/9fabeced20994f2adac745364ebd8aed4f82d848.png" width="593" height="499">
<img src="/uploads/default/original/1X/9d4b953d8fb26da446008dab55fb0f4f961159dd.png" width="565" height="87">

---

## Post #6 by @irus26

It should work.

First delete everything between JobNum and MinOprSeq.

Test it just with those 2 fields, and then you may insert additional columns.

---

## Post #7 by @Olga

But additional columns will have to be aggregated somehow as well.

---

## Post #8 by @astrys

It is working now, for the most part!
I added all the other columns back in and the results were the same until I tried to add the OpCode back and it showed all of the Operations in each job again.

---

## Post #9 by @Patrick

On the join to JobOper can you select FIRST EACH or LAST like in Epicor 9.
Selecting FIRST would be a much better method than passing all the job operation records and picking the first one for performance reasons.

Patrick Winter

---

## Post #10 by @astrys

I don't think I have that option.
We are on version 10.1.400.13.

<img src="/uploads/default/original/1X/ca3a82e7f2b0e3614a1527a5fc79c5d146c8c6c7.png" width="689" height="453">

---

## Post #11 by @irus26

Try to do min of OpDesc as well

---

## Post #12 by @srossberg

Assuming you need to display data from both the JobHead and JobOper  tables  I would suggest this:

1. Create an Inner subquery using just the JobOper table.
	Select jobNum to display and check group by
	Create a calculated field as suggested: MIN(JobOper.OprSeq) 
2. Create a top level subquery with all the tables you wish to include
	Add the subquery to the top level query
	Join the subquery to the JobOper table on JobNum to JobNum and OprSeq to Calculated_OprSeq

---

## Post #13 by @astrys

GREAT!
That worked perfectly.

Thank you so much.

---


**Canonical:** https://www.epiusers.help/t/baq-to-show-the-first-operation-on-a-job/36518
**Original content:** https://www.epiusers.help/t/baq-to-show-the-first-operation-on-a-job/36518