Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Risks & Issues

SOLVED
Go to solution
Highlighted
Dominic Almeida
Regular Collector

Risks & Issues

Hello Guys

How can I fetch Risks or Issues of any particular Project through SQL?

I'm unable to find the table for Risks or Issues, anybody knows??

BR - Dom
2 REPLIES
Hameed Hussain
Super Collector
Solution

Re: Risks & Issues

Here you go ...

SELECT * FROM KCRT_FG_MASTER_PROJ_REF WHERE REQUEST_ID=YOUR_REQUEST_ID

Here's the join

SELECT A.REQUEST_ID,A.DESCRIPTION, B.* FROM KCRT_REQUESTS A
INNER JOIN KCRT_FG_MASTER_PROJ_REF B ON B.REQUEST_ID=A.REQUEST_ID
WHERE A.REQUEST_ID=30211

I hope you can work it out from here onwards.. :)

regards - hussain
Dominic Almeida
Regular Collector

Re: Risks & Issues

Hay buddy,

thanks for a very quick reply.

my problem is resolved, thanks for the help.

BR - Dom
//Add this to "OnDomLoad" event