AnsweredAssumed Answered

how to Join resource OBS with Resource details, Pojects Actuals - SQL?

Question asked by Riya on Aug 8, 2013
Latest reply on Aug 9, 2013 by Owen_R
Hi all,

I need to get a raw details( at the monthly level/weekly) of the "Project Labor Actuals Portlet" but with the added level of individual Resource and OBS(time reporting) with its child. Please let me if you have a SQL that helps to achieve my goal.
I'm new to clarity with little bit of knowledfe with clarity database.

So basically i need
Proj name
Proj mgr
resource Department OBS with its child
resource name
Actuals
time period

Please let me know. Thanks in advance!

I attached the "Project Labor Actuals Portlet" from clairy. so you know which one i'm refering too

Attachments

Outcomes