Getting Material Part Revision onto BOM List Query

Good morning team,

Does anyone know how to properly get the material part revision onto the indented BOM List query, like how it’s displayed on the BOM List report? I created the one straight from the Ice manual but am now having a hell of a time to get the right rev.

I have searched EpiUsers for this but nothing came up fruitful.

I want to say one of the BAQ Tech refs has this exact use case as an example of how to build recursive queries.

EDIT: It’s actually in the built-in help. Hit F1 and search for “Common Table Expression Query”

There’s other useful examples under the “Case Studies” topic.

I copied the query from the Ice Manual but there was nothing specific about adding the revision for the MaterialPartNum. It keeps pulling the revision for the Parent Part.

I solved it. Had to create another InnerSubQuery to get the max revision and do a left join with the TopLevel.

Thanks for your input.

image