1 Reply Latest reply: Mar 23, 2013 2:49 PM by 996997 RSS

    SkillBuilders Schedule Plug In

    996997
      I have a question regarding the Schedule Plug In. Two tables are created, one is App_people and the other is App_Events. The Primary key of App_people is person_id and the primary key of App_Events is event_id, person_id is a foreign key of App_events.

      I used the Schedule Plug In for the table App_Events.

      But something happened after the plug In?

      Scenario One: Use the Row ID as a primary key to join the two tables. It works but the schedule table is unable to keep the old record of the schedule time I put. It keeps going to replace the existing one only. It means it keeps only one record.

      Scenario Two: Use the Person_Id for App_people table and Event_id for App_Events table as a Primary Key.
      An error occured on App_Events table after joining two tables. No data found in App_events and got the message See the Developer.

      Just wonder how could I keep the old and update the Schedule Time record under the same Person_ID?

      Scenario Three: Should I create a new table to include or combine all the field names of Table App_people and App_events, then applying the Schedule Plug In? Does it work? Does it allow me to update and keep old records together? Or do I need to uncheck the update on the Page Processing?

      Script is as follows:

      CREATE TABLE APP_EVENTS (
      EVENT_ID NUMBER NOT NULL,
      PERSON_ID NUMBER NOT NULL, -- foreign key to your personnel table
      EVENT_TITLE VARCHAR2(100),
      EVENT_SCHEDULE VARCHAR2(500) NOT NULL,
      constraint FURLOUGH_EVENTS_PK primary key (EVENT_ID)
      );


      select p.fullname, sbip_schedule.start_date(e.event_schedule) start_date
      , sbip_schedule.end_date(e.event_schedule) end_date
      , sbip_schedule.duration_seconds(e.event_schedule) duration_seconds
      , sbip_schedule.calendar_summary(e.event_schedule) calendar_summary
      from app_events e, app_people p
      where p.person_id = e.person_id
      (Script of joing two tables - but no data was found?)


      select p.fullname, sbip_schedule.start_date(e.event_schedule) start_date
      , sbip_schedule.end_date(e.event_schedule) end_date
      , sbip_schedule.duration_seconds(e.event_schedule) duration_seconds
      , sbip_schedule.calendar_summary(e.event_schedule) calendar_summary
      from app_events e
      (Script of joining two tables, Do you think is is possible to keep and update the records ?

      Thanks!




      select p.fullname || ' - ' || sbip_schedule.duration_seconds(e.event_schedule) / 3600 title
      , d.column_value event_date
      from app_events e
      , app_people p
      , table(sbip_schedule.dates(e.schedule)) d
      where p.person_id = e.person_id