Latest Rev from Agile DB

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

Thanks.

Add Comment
2 Answer(s)
Best answer

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

Thanks,
Sagar

Agile User Answered on June 3, 2015.
Add Comment

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.

Agile User Answered on June 11, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.