search cancel

Resource calendars: working and non-working days

book

Article ID: 219159

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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?

Resolution

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.
 
SELECT
RES.PRNAME CALENDAR_NAME
,PRJ_BLB_SLICES.SLICE_DATE
,PRJ_BLB_SLICES.SLICE
,RES.LAST_NAME
,RES.FIRST_NAME
,RES.UNIQUE_NAME
,RES.ID
FROM
PRJ_BLB_SLICES
,PRJ_BLB_SLICEREQUESTS
,
(SELECT 
 SRM_RESOURCES.ID
,SRM_RESOURCES.LAST_NAME
,SRM_RESOURCES.FIRST_NAME
,SRM_RESOURCES.UNIQUE_NAME
,PRCALENDAR.PRID
,PRCALENDAR.PRNAME
FROM
SRM_RESOURCES
,PRJ_RESOURCES
,PRCALENDAR
WHERE
SRM_RESOURCES.ID = PRJ_RESOURCES.PRID
AND PRJ_RESOURCES.PRCALENDARID = PRCALENDAR.PRID
AND PRCALENDAR.PRRESOURCEID is NULL) RES
WHERE
PRJ_BLB_SLICEREQUESTS.ID =PRJ_BLB_SLICES.SLICE_REQUEST_ID
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