Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using jquery FullCalendar in APEX with dynamic query

772110May 10 2010 — edited May 11 2011
Hi,
I am trying to implement jquery FullCalendar in APEX and came across thie following post but I am unable to get the events to work. I would really like to see it working with an Application_Process:
4073226

Currently I created an Application Process that simply calls a DB table and convert it into json format.

DECLARE
v_sql varchar2(400);
BEGIN
v_sql := 'SELECT * FROM CAL_FEED';
apex_util.json_from_sql(v_sql);
END;

But I am unsure how to add the events via an Application_Process.
I have tried the following in numerious ways (events:function, url feed, etc). It does work if I just do an array but would like it as a dynamic query.

$('#calendar').fullCalendar({
events: "http://server:8080/apex/f?p=101:53:4352610578859707:APPLICATION_PROCESS=IAT_TEST_CAL_FEED"
});

Thank you in advance,
Jimmy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on May 10 2010
5 comments
2,545 views