BAQ help Getting Last Revision

[Rochelle (Rochelle Gilbert)]

I’m trying to write a BAQ to tell me if the revision is approved for the Part Number and all the material underneath it.

I’ve been able to find a BAQ to run the Parent P/N with the BOM several levels in. But I can’t figure out how to add in the Approved column (correctly).

Thanks for any help!

[Nicholas_Mueller]

The Approved field is found in PartRev table if you add this to your BAQ you can pull it in.

[hkeric.wci (Haso Keric)]

There is an example BAQ attached:

Get latest PartRev in a BAQ

[image] Attached TEAGLE-LastPartRevision.baq (31.6 KB) You prob should maybe change the joins to Left Join so you could show blanks [image] Thats the method I linked you above in my previous post:

Basically if you have a Inner-Subquery but you do not use it in your Main-SubQuery how can use it in a Calculated field using the {InnerSubQueryName} syntax.

Using Count() in BAQ - Incorrect Syntax

@tmcmullen you can also do Sub-Select SubQuery. Then you wouldnt need to do GROUP BY on your Top-Query. In a Nutshell: Make a Sub-Query but DO NOT Use it on the Designer On your TopLevel Query add the Sub-Query to a Calculated Field On the Sub-Query under SubQuery Criteria you can add WHERE Clause. Example: SubQuery1: [image] [image] SubQuery2: [image] [image] Result: [image] [image] Basically in a simpler view it does SELECT (SELECT count(*) FROM table WHERe...) as YourCalculate…