BOM data for each revision from Agile DB
Not easily. You would have to get all rev changes, and construct a query along the lines of :
select * from bom where item = (select id from item where item_number='<assembly#>’)
and change_in IN (0,<all rev change IDs previous and including revision you wish the data for >)
and change_out NOT IN (<all rev change IDs previous and including revision you wish the data for>);
There are lots of component item P2 attributes that are commonly shown in the BOM tab, so you would have to get those separately for each component.
Yes, this is complicated, but the number of records needed to hold a large multi-revision BOM is MUCH less than what you would think, even if the BOM has been modified a lot. And with the indexes that are on the BOM table, it works pretty efficiently.