Question regarding pending changes in SQL Developer
Hi,
Is there any table in SQL developer where I will be able to find items which has pending changes?
Regards,
Achuth
Hi Achuth,
Could you please update the Agile and DB version for exact answer.
you can try this table “item_p2p3_query_all_rev” get the pending change details for Agile 9.3.5.
Regards,
Ganesh
Agile User
Answered on May 30, 2017.
Hi
you can use the below query to fetch all the items which were undergoing changes from item table.
select * from ITEM where FLAGS like ‘00010%’;
Regards
Srini
There are several tables to look at (and ways) to do this. Probably the easiest is :
select i.item_number, r.rev_number, c.change_number from rev r, item i, change c
where i.id = r.item and r.change > 0 and c.id=r.change and c.statustype not in (3,4);
This way you have the item number and any change/revision that is not yet released (the status type is not released or implemented).
If all you really want is just a unique list of item numbers, then :
select distinct i.item_number from rev r, item i, change c
where i.id = r.item and r.change > 0 and c.id=r.change and c.statustype not in (3,4);
The ITEM_P2P3_QUERY_ALL_REV will work, but you will have to add criteria in the query to pick out just the pending ones. Using the FLAGS attribute from ITEM also works, but I have seen databases where FLAGS is not always up to date (when was the last time you ran Averify on your database??). STATUSTYPE is better than most in always being up-to-date and correct..
