Santosh-Komeravelli

Need to get the Resource Shift timings from Calendar

Discussion created by Santosh-Komeravelli on Dec 22, 2015
Latest reply on Dec 22, 2015 by urmas

Hi All,

 

We have a requirement to develop a portlet/report to show the Resource Shift timing and Worktype (Work-day or non-work day) details as the columns. I am unable to find the table name to get the data for the resource shift timings. I have checked in PRJ_RESOURCES, PRCALENDAR tables, but unable to get the required data.

 

Can anyone help me in getting the shift timings and work-type details from the database table?

 

Is this data is stored in any BLOB type, if so can you please help in providing the database table name and the workable snippet code to convert the BLOB type to text.

 

Thanks.

Outcomes