The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Project Risk Query

SOLVED
Go to solution
Highlighted
Sevilay
Collector

Project Risk Query

Hi,

on PPM database in which table the project risks are stored? In other words how can i find a specific project's risks with sql query?

Thanks in advance.

Any help will be much appreciated.
2 REPLIES
Jason Nichols K
Honored Contributor
Solution

Re: Project Risk Query

Project Risks are Requests, just like Projects Issues or Projects themselves. The Risks will be stored in the KCRT_REQUESTS tables with data also being stored in the KCRT_REQ_HEADER_DETAILS and potentially KCRT_REQUEST_DETAILS tables. You will need to tie them together with the KNTA_REFERENCES table.
Sevilay
Collector

Re: Project Risk Query

Hi Jason,

i have already wrote the query.

All in all thank you very much.

Have a good day.
//Add this to "OnDomLoad" event