1. App Builder User's Guide
  2. Managing Application Data
  3. Managing REST Enabled SQL References
  4. Creating or Updating Components to Use a REST Enabled SQL
  5. Creating a Calendar Using a REST Enabled SQL Reference

Creating a Calendar Using a REST Enabled SQL Reference

Create a calendar on a remote database using a REST Enabled SQL reference.

Tip:

Before creating a report using a using a REST Enabled SQL reference, you must complete the tasks described in "Before You Begin: REST Enabled SQL Service Requirements" and create the reference as described in "Creating a REST Enabled SQL Service Reference."

To create an calendar REST Enabled SQL Reference:

  1. Create REST Enabled SQL reference.
  2. On the Workspace home page, click the App Builder icon.
  3. Select the application.
  4. Click Create Page.
  5. On Create a Page:
    1. User Interface - Select a user interface for the page (optional).
      This attribute only displays for applications using older themes and for which Desktop and Mobile User Interfaces have been defined.
    2. Page Type - Select Component and then Calendar.
  6. For Page Attributes:
    1. Page Number - Enter a page number. If you identify a new page number, the wizard creates a new page. If you identify an existing page number, the wizard adds the component to that page.
    2. Page Name - Specify a name for the page.
    3. Page Mode - Identify the page mode.
    4. Page Group - Identify the name of the page group you would like to associate with this page.
    5. Breadcrumb - Select whether you want to use a breadcrumb navigation control on your page, and which breadcrumb navigation control you want to use.
    6. Click Next.
  7. For Navigation Menu:
    1. Select how you want this page integrated into the Navigation Menu. To learn more, see field-level Help.
    2. Click Next.
  8. On Source:
    1. Data Source - Select REST Enabled SQL Service.
    2. REST Enabled SQL Service - Select a previously defined reference.
    3. Source Type - Specify the source of the new page. Reports can be based on tables or SQL queries. Select either Table or SQL Query. In the illustration that follows, the Source Type is Table.
    4. Table/View Owner - Select the owner of the table on which you are building a report.
    5. Table/View Name - Select the table on which you are building a report.
    6. Select Columns - Select one or more columns to be included in the region. Selected columns will display in the report.
  9. For Settings:
    1. Display Column - Select the column which holds the text displayed for events on this calendar.
    2. Start Column - Select the column which holds the start date for events displayed on this calendar.
    3. End Date Column - Select the column which holds the end date for events displayed on this calendar. If this attribute is specified, then the calendar displays duration based events
    4. Show Time - Select whether the time portion of the date should be displayed. The Week and Day views only be display when Show Time is set to Yes. If the start date or end date columns do not include time components they will be shown as 12:00 am.

      For example, the next illustration shows Settings in which the Display Colum is Name, the Label Column, START_DATE, and the End Date Column is END_DATE.

      Description of rest_enabled_sql_calendar.png follows
      Description of the illustration rest_enabled_sql_calendar.png
    5. Click Create.
    Page Designer appears.
  10. Click Save and Run Page to view the report.

See Also:

"Understanding Page Types in the Create Page Wizard"

Parent topic: Creating or Updating Components to Use a REST Enabled SQL