How can we check the working and non-working days of the Clarity resources? Is there a way to get an extract of the Clarity calendar working and non-working days?
The calendar data is stored on a BLOB.
The calendar is in PRCALENDAR.PRVALUE, which is a BLOB... hence it cannot be looked into.
Time slice 1 [Daily Availability] gives some information about the resource's availability....
But it's not the resource's whole Calendar... far from it...
The usual limits about time slices apply: they will only show "a window" of the resource's availability/calendar...
The query below will give you an extract of the Daily Resource Availability Curve together with the calendar associated to each resource.
The daily slice value will show you the number of hours worked by each resource a day.
SRM_RESOURCES.ID = PRJ_RESOURCES.PRID
AND PRJ_RESOURCES.PRCALENDARID = PRCALENDAR.PRID
AND PRCALENDAR.PRRESOURCEID is NULL) RES
AND PRJ_BLB_SLICEREQUESTS.REQUEST_NAME = 'DAILYRESOURCEAVAILCURVE'
AND PRJ_BLB_SLICES.PRJ_OBJECT_ID = RES.ID
AND RES.ID = XXXXXXXX
ORDER By RES.PRNAME, PRJ_BLB_SLICES.SLICE_DATE