17.3.7.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: Normal or Modal.

      See field-level Help for more details.

5. Under Data Source:
   1. Select how you want this page integrated into the Navigation Menu. To learn more, see field-level Help.
   2. Click Next.
6. 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. 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.

7. Navigation - Expand the region and enable or disable navigation. If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.
   1. Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
   2. Navigation - Enable to create a navigation menu entry for this page. By default, the page name is used as breadcrumb entry name.
   3. 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