AnsweredAssumed Answered

Resource Calendar Portlet

Question asked by Kaushal.kishore on Jan 16, 2013
Latest reply on Jan 30, 2013 by Kaushal.kishore
I want to create a portlet which shows resource calendar (When Filtered by Resource and Start Day and End Day).
The sample data is as :

Resource _________________Week of 14/Jan/201__________________

14/Jan 15/Jan 16/Jan 17/Jan 18/Jan
Kaushal Holiday Available Vacation Available Vacation

I can get Whether the date is holiday or not by using the query (Which is giving the holidays of resource):-

SELECT @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:s.ID:SliceId@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.PRJ_OBJECT_ID:ResorceID@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.FIRST_NAME:FirstName@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.Last_NAME:LastName@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:s.SLICE_DATE:NonWorkingDays@
FROM
(

select s.ID,s.PRJ_OBJECT_ID, R.FIRST_NAME, R.LAST_NAME, s.SLICE_DATE from prj_blb_slices s
JOIN SRM_RESOURCES R on R.ID = S.PRJ_OBJECT_ID
where slice = 0

) s

Where slice_date BETWEEN @where:param:user_def:date:paramstartdate@ AND @where:param:user_def:date:paramenddate@


AND @FILTER@






Someone who has done this earlier can help me achieve this.

Regards
Kaushal

Outcomes