Project and Portfolio Management Practitioners Forum
cancel

Risks & Issues

SOLVED
Go to solution
Highlighted
Dominic Almeida
Respected Contributor.

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
Trusted Contributor.
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
Respected Contributor.

Re: Risks & Issues

Hay buddy,

thanks for a very quick reply.

my problem is resolved, thanks for the help.

BR - Dom