Manually create a calendar in Page Designer by providing the SQL query.

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. If necessary, click the Layout tab in the central pane.
3. In the Gallery, click the Regions tab.
4. Right-click Calendar, click Add To, and select the appropriate location.

   Tip:

   You can also select Calendar with the mouse and drag it to the appropriate location in the Layout tab.
5. Page Designer indicates what to do next. If there is an error, the Show Messages icon displays in the Page Developer toolbar.
   1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
   2. Select an error to highlight the associated attribute in the Property Editor.
6. In the Property Editor, edit the appropriate Region attributes:
   • Identification, Title - Enter a region title.
   • Source, Location - Select the location of the database which contains column which holds the CSS Class to style the events displayed on this calendar. Options include:

     • Local Database - Data is sourced from a local database.

     • REST Enabled SQL - Data is sourced from a remote database, where the connection is defined using REST Enabled SQL. To create or maintain REST Enabled SQL references, navigate to Shared Components, REST Enabled SQL Databases.

     • REST Source - Data is sourced from a RESTful web service defined using REST Data Sources. To create or maintain REST Data Sources, navigate to Shared Components, REST Data Sources.

     • Duality View - Data is sourced from a Duality View Source defined using Duality Views within Shared Components.

     • JSON Source - Data is sourced from a JSON Source defined using JSON Sources within Shared Components. JSON Sources include tables with JSON columns or JSON Collection Tables.

     What displays next depends upon Source, Location you select.

     Tip:

     To learn more, select the attribute in the Property Editor and click the Help tab in the central pane.
7. Edit the calendar Attributes.

   • In the Rendering tab, locate the Calendar region and click Attributes.

     The Property Editor displays the calendar Attributes.

   • Edit the calendar Attributes:

     • Settings, Display Column - Select the column which holds the text displayed for events on this calendar.

     • Settings, Start Date - Select the column which holds the start date for events displayed on this calendar.

8. Click Save.