Find Unincorporated Released Items

I am trying to find all the Released items in my Agile PLM system that are not Incorporated. Does anyone know how to search or query for it in the Agile DB?

Thank you
David

No Files Were Attached
davidvinas Agile User Asked on October 11, 2018 in Product Collaboration.
Add Comment
2 Answer(s)

There is a flag in the REV table named INCORPORATED that is set when a revision has been incorporated.
 A query to select revisions that are released but not incorporated would be something like :
select i.item_number, r.rev_number, c.change_number
 from item i, rev r, change c
where i.id = r.item and (r.incorporated is null or r.incorporated = 0)
    and r.change = c.id and c.statustype in (3,4);

 INCORPORATED can be null, 0 or 1, with 1 indicating that the revision has been incorporated. STATUSTYPE in the CHANGE table indicates the type of status for the change – 0=Pending, 1=Submitted, 2=Review, 3=Released, 4=Implemented, 5=Cancel, 6=Hold.  So the query looks for a revision where INCORPORATED is null or zero, and where the related change has STATUSTYPE equals 3 or 4.

Kevin Cummings Agile Angel Answered on October 11, 2018.

It did not occur to me to check the REV table, I was looking at the FILE and ATTACHMENTS tables. Thanks, I will give it a shot and report back.

David

on October 11, 2018.
Add Comment

A slight tweak to the query

Rev table also has RELEASED column. So, you could just look at that. When you do a join on change, look for c.class = 6000. This will make sure you look at only ECOs

rchinnia Agile Talent Answered on October 12, 2018.
Add Comment

Your Answer

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