18.6.10.3 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 a calendar using a REST Enabled SQL reference:

1. Create a REST Enabled SQL reference.
2. Run the Create Page Wizard:
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Create Page.
      Create a Page appears and features three tabs: Component, Feature, and Legacy Pages.
3. Under Component, select Calendar.
4. Under Page Definition:
   1. Page Number - The page number is an integer value that identifies a page within an application.
   2. Name - Specify a text name for this page.

      Tip:

      This text is also used for page Title. After page creation, you can modify the Title in Page Designer.
   3. Page Mode - Identify the page mode. To learn more, see field-level Help.
5. Under Data Source:
   1. Data Source - Select REST Enabled SQL.
   2. REST Enabled SQL Service - Select a previously defined reference.
   3. Source Type - Specify the source of the new page. The UI changes based on your selection. Options include:

      • Table:

        • Table /View Owner - Select the owner of the table on which you are building the page.

        • Table/View Name - Select the table or view on which the page will be based.

      • SQL Query:

        • Enter a SQL SELECT statement - Enter the SQL query. To see an example, expand the SQL Query Example region.

6. Navigation - If needed, expand the region. Enable or disable the following flags:
   1. Use Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
   2. Use Navigation - Enable to create a navigation menu entry for this page. By default, the page name is used as navigation menu name.

   If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.

7. Click Next.
8. Edit the calendar attributes:
   1. Display Column - Select the column which holds the text displayed for events on this calendar.
   2. Start Date 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 End Date is specified, then the calendar displays duration based events.
   4. Show Time - Select Yes to show the time portion for events and also enable the Weekly and Daily calendar views. Select No to only show the dates for events.
9. Click Create Page.
10. Click Save and Run Page to view the chart.

See Also:

Creating Calendars