This content has been marked as final. Show 5 replies
You could do it with an POP-UP LOV and Dynamic Action.
- item P65_STAFF_ID
1 - PL/SQL block;
- PL/SQL Code in this block you can get the last of first date for the absence of the STAFF_ID and put it in the date item for the calendar (eg P65_CALENDAR_DATE);
- Page Items to Submit P65_STAFF_ID
- Page Items to Return P65_CALENDAR_DATE
This way the calendar will be refreshed and set to the date in P65_CALENDAR_DATE.
I made a small example at http://apex.oracle.com/pls/apex/f?p=14257:4 (login as demo/demo).
If the question is answered please change it to answered and mark the appropriate post as correct/helpfull.
And hard-coding the calendar view to monthly ignoring the current view you are in. It always shows the monthly view!
You are totaly right, it was a quick example.
Off course you can use the hidden item for the calendar type in the call to preserve the current view.
or even better use 'S' (short for same? ;-))
Edited by: kvlek on 5-apr-2013 10:45