I’m trying to build a BAQ that shows PartRevs that have a method but no Operations that are not phantom. I was going to left join PartRev on PartOpr and return any PartRevs that are not in the PartOpr Table. I cant get it to work with a sub-query.
Any thoughts?
Try creating a sub query using the ‘Except’ function
The attached is a very simple example.
ACTEST.baq (21.5 KB)
You could look at the PartMtl.RelatedOperation field. If this is blank, then no operations.
You could also make a subquery with PartRev left joined to PartOpr. GroupBy PartNum and Rev and Count the number of operations per PartRev. Then in the top level, filter out all the Parts with non-null number of operations.
You can’t have the field in your displayed fields, and use that field in an aggregate. (I’m assuming that’s that you have going on since the field is showing up in your database fields section).
Thank you. that worked.