Clarity PPM

Expand all | Collapse all

Does anyone know how to query the Base Calendar data from database?

Jump to Best Answer
  • 1.  Does anyone know how to query the Base Calendar data from database?

    Posted 05-02-2018 04:46 PM

    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



  • 2.  Re: Does anyone know how to query the Base Calendar data from database?

    Posted 05-02-2018 07:22 PM

    Hi Julian

     

    Did you have a look at this post:

     

    SQL Query to Base Calendars 

     

    It might help.

     

    Thanks

    Shailey



  • 3.  Re: Does anyone know how to query the Base Calendar data from database?



  • 4.  Re: Does anyone know how to query the Base Calendar data from database?

    Posted 05-03-2018 02:15 PM

    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. 



  • 5.  Re: Does anyone know how to query the Base Calendar data from database?
    Best Answer

    Posted 05-03-2018 02:54 PM

    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



  • 6.  Re: Does anyone know how to query the Base Calendar data from database?

    Posted 05-03-2018 04:12 PM

    thanks, that worked!