Home

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

Agile User Asked on October 11, 2018 in Agile PLM (v9),   Product Collaboration.
Add Comment
Cancel
2 Answer(s)
Cancel
Agile Angel Answered on October 11, 2018.

davidvinas

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.
Cancel
Add Comment
Cancel

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

Cancel
Agile Angel Answered on October 12, 2018.
Add Comment
Cancel

Your Answer

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