Extract Criteria and Privileges data from Oracle Agile PLM

I’m trying to write SQL queries to extract all the Criterias and properties associated to it and the same for privileges from Agile PLM database. I’m using Nodetable and Propertytable but still not getting the actual results. Any support here would be very helpful.

Agile User Asked on January 18, 2021 in Product Collaboration.

Using below query, i’m able to extract basic details of criteria. But i’m unable to extract the condition related to the criteria

select n.description CRITERIANAME, n2.description OBJECT_TYPE, n.created as createddate, n.last_upd
from nodetable n, propertytable p, nodetable n2
where n.objtype=111 and n.id=p.parentid
and p.propertyid=53 and to_number(p.value) = n2.id
order by n.description;

on January 18, 2021.
Add Comment
2 Answer(s)

Hello

Agile already provides the

Criteria Library Configuration Report

under Standard -> Administrative reports which gives all the info that you are looking for. Have you tried this?

– Raj

Agile Expert Answered on January 18, 2021.

Hi Raj,

Thanks for your suggestion !!

I actually need to extract this data from database. The above mentioned report doesn’t provide the criteria create date or last updated date.

Regards,

Achuth

 

 

 

on January 19, 2021.

That’s true. It doesn’t provide the timestamp

There is a table called CRITERIA that holds each line of the criteria as one row. So, it is not stored as the text that you see in administrator.

When you go to JC and click on a criteria, Agile pulls it from this table (not sure how it gets the parent id) and displays it in readable form. So, definitely challenging 🙂

on January 23, 2021.
Add Comment

Very thanks for both suggestions

Agile User Answered on January 19, 2021.
Add Comment

Your Answer

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