BAQ Question - How to filter all jobnum that have at least 1 openRelease in PORel

Epicor ERP 10
1

Hello,

I was asked about this but I am not quite getting there.
A friend is trying to develop a BAQ that will only show jobs where ALL openRelease are False.
If the job has a true for an openRelease, it should not show that job in the report.

I would assume it is done with a subreport but not sure how to stop a jobs that fail criteria from showing.

Any ideas?

Thanks,
Shawn

2

Yes this would need a subquery.

the final query would be something like

select distinct(master.jobNum)
from ERP.PORel As master
where
master.JobNum NOT IN (select distinct (JobNum) from PORel where OpenRelease = true)

3

How do I get something to be distinct in the Epicor BAQ Designer?

4

Capture
Capture.JPG714×495 40 KB

5

I will give it a try.
I appreciate your helping me!

Thanks,
Shawn