Latest Rev from Agile DB

Question

Home

Answered

How to fetch the latest Revision of an Item from the Agile DB?

Thanks.

PLM_admin Agile Angel Asked on June 2, 2015 in Agile PLM (v9), Product Collaboration.

Add Comment

2 Answer(s)

You can execute the below query to get the latest revision of an item from Agile DB.

select i.item_number,r.rev_number from item i, rev r where i.item_number='<Item Number>’ and r.item=i.id and i.default_change=r.change

Regards,
Anand.

ashivraj Agile User Answered on June 11, 2015.

Add Comment

Sagar KC · Accepted Answer · 2015-06-03 00:00:00

Best answer

From the rev table, with latest flag column considered you will be able to get latest rev of item.

Thanks,
Sagar

Sagar KC Agile User Answered on June 3, 2015.

Add Comment