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

Add Comment
2 Answer(s)
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

Agile Professional Answered on October 12, 2018.
Add Comment

Your Answer

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