Forum Discussion
Gopikrishnan
7 years agoIdeator I
Thanks Christopher. This looks to be a simple. However if the latest generation is released, then the combined query will fail as latest revision is_released = '1'. so, second query might return no records.
<AML>
<Item type="Part" action="get" select="item_number,generation,major_rev">
<item_number>TESTPART1</item_number>
<generation condition="gt">1</generation>
<is_released>1</is_released>
</Item>
<Item type="Part" action="get" select="item_number,generation,major_rev">
<item_number>TESTPART1</item_number>
<is_released>0</is_released>
</Item>
</AML>
Maddy
7 years agoIdeator I
Thanks Gopikrishnan and Chris for helping on this, I will try with this approach,