Getting Material Part Revision onto BOM List Query

[mjf1143 (Michael Foreman)]

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.

[jtownsend (John Townsend)]

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.

[mjf1143 (Michael Foreman)]

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.

[mjf1143 (Michael Foreman)]

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.