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 18.104.22.168
Did you have a look at this post:
SQL Query to Base Calendars
It might help.
Some more links inNeed auery to get the list of holidays from the Calender
and an answer in
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.
Select top 100000Srm_RESOURCES.id,Srm_RESOURCES.unique_name,Srm_RESOURCES.full_name,prcalendar.Hours_per_day,
prcalendar.prnamefromsrm_RESOURCES,PRJ_RESOURCES,prcalendarwhereprcalendar.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!