Hi Steeves,
You have to use the slice tables for getting the daily info.
JOIN PRJ_BLB_SLICES ON PRTIMEENTRY.PRID = PRJ_BLB_SLICES.PRJ_OBJECT_ID
And mention the slice id which you want to use depending on the data you need and then extract the hours .
Regards,
Supriya Chakraborty
From: CA Clarity Global User Community [mailto:
CommunityAdmin@communities-mail.ca.com]
Sent: Wednesday, August 21, 2013 11:36 PM
To:
mb.2277340.101626302@myca-email.ca.com
Subject: [CA Clarity General Discussion] Break PRTIMEENTRY Into Daily Totals
Hi. I've been working on this for over a week now, and desperately seeking some assistance.
So far I've come up with the following query, which seems to bring back all our Indirect Time from the PRTIMEENTRY table, by week. So one record would return 40 hours, if that person had 5 vacation days in the current week.
How can I break this down into daily detail? So that I could query an exact month, from the 1st to the 31st, without worrying that the 1st may fall mid week on an actual time sheet. I found a few related posts, but I can't make them work. Can somebody help me simplify it? Here is my current query:
SELECT S1.First_Name,S1.Last_Name, P2.PRNAME, P1.PRACTSUM, (P1.PRACTSUM / 3600) as TimeAlloted, P4.PRSTART,P4.PRFINISH FROM CLARITY.PRTIMEENTRY P1 Inner Join clarity.prchargecode P2 on
P1.PRCHARGECODEID = p2.PRID Inner Join Clarity.prtimesheet P3 on
p3.PRID = P1.PRTIMESHEETID INNER JOIN CLARITY.srm_resources S1 ON
S1.ID = P3.PRRESOURCEID INNER JOIN clarity.prtimeperiod P4 ON
P4.PRID = P3.PRTIMEPERIODID
WHERE P1.PRASSIGNMENTID is null
Posted by:shane.steeves
--
CA Communities Message Boards
101628842
mb.2277340.101626302@myca-email.ca.com<mailto:
mb.2277340.101626302@myca-email.ca.com>
https://communities.ca.com