18.6.10.2 Creating a Chart Using a REST Enabled SQL Reference

Create a chart 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 chart 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 Chart.
4. Select a chart type (for example, Pie).
5. 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.
6. 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.

7. 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.

8. Click Next.
9. Edit the chart attributes. The options that display vary depending upon the chart type selected. To learn more about an attribute, click the field-level Help.
10. Click Create Page.
11. Click Save and Run Page to view the chart.

See Also:

Creating Charts