Hi,
I`m writting now a query, which should return me a monthly timesheet ,division for days. This schedule should have daily work schedule from day to day (1-8h, 2-8 h, 3-5 h......).. How can i do this? I need this query, because i must use it in my crystal object report. Which table i must to use? I need to make a daily slices in Clarity?
Have you checked this?
Getting Timesheet Data using NSQL
https://communities.ca.com/thread/99554975
NJ
The link provided by navzjoshi00 above gives all that is required. But just to summarize:
1. Make sure that the Time Slices have enough range
2. Run the Time Slicing Job
3. Query PRJ_BLB_SLICES on SLICE_REQUEST_ID = 1