Clarity

Clarity PPM Question - 

Does anyone know how to query the Base Calendar data from database? I noticed that there's a PRCALENDAR table but that only has a few records for us. So we want the Resources and their associated Base Calendar. 

I was wondering if there's something that can provide how each Base Calendar is broken down from the db. 

We're on Version 14.4.0.8

Thanks

Hi Julian

Did you have a look at this post:

SQL Query to Base Calendars 

It might help.

Thanks

Shailey

Some more links in
Need auery to get the list of holidays from the Calender 

and an answer in

https://communities.ca.com/message/99253912?commentID=99253912#comment-99253912 

Thanks. I'm trying to see if the PRCALENDAR is also not showing everyone. We have about 1000 users.  The PRCALENDAR table only has 190 records.  

I'd like to see everyone with the type of Base Calendar that they are assigned.  Is this possible? Or, is there a problem with the table.  

No need to look at the availability slices on this matter. 

Try

Select top 100000
Srm_RESOURCES.id,
Srm_RESOURCES.unique_name,
Srm_RESOURCES.full_name,
prcalendar.Hours_per_day,

prcalendar.prname
from
srm_RESOURCES,
PRJ_RESOURCES,
prcalendar
where
prcalendar.prid = PRJ_RESOURCES.prcalendarid and PRJ_RESOURCES.prid = SRM_RESOURCES.id

/* and prcalendar.Hours_per_day <> 7.5 */

Order by Srm_RESOURCES.full_name

thanks, that worked!