1. App Builder User's Guide
  2. Managing Application Legacy Components
  3. Creating Legacy Maps

25.4 Creating Legacy Maps

App Builder includes built-in wizards for generating map charts. How you create a map chart depends upon whether you are adding the map to an existing page, or adding a map on a new page.

Note:

Although still supported, map charts have been categorized as a legacy component and may be deprecated in a future release. To learn more, see "Removal of AnyChart Flash Components from Images Folder" in Oracle Application Express Release Notes.

Parent topic: Managing Application Legacy Components

25.4.1 About Map Chart Support

Map chart support in Oracle Application Express is based on the AnyChart AnyMap Interactive Maps Component.

AnyMap is a flexible Macromedia Flash-based solution that enables developers to visualize geographical related data. Map charts are rendered by a browser and require Flash Player 9 or later. For more information about AnyChart, go to http://www.anychart.com

AnyChart stores map data in files with a *.amap extension, and supports 300 map files for the United States of America, Europe, Asia, Europe, Africa, Oceania, North America, and South America. To render a desired map, you select the map source in the wizard (for example, Germany) and the map XML automatically references the desired map source .amap file, germany.amap. To browse through the available maps, see "Map Reference" in AnyChart User's Guide: http://6.anychart.com/products/anymap/docs/

Parent topic: Creating Legacy Maps

25.4.2 About Creating SQL Queries for Maps

Define a map chart by providing a SQL query with a specific syntax.

When you define a map chart providing a SQL query using the following syntax:

SELECT link, label, value
FROM   ...

Where:

  • link is a URL.

  • label is the text that identifies the point on the map with which you want to associate data. The Region ID or Region Name of the map will be used as the label.

  • value is the numeric column that defines the data to be associated with a point on the map.

Consider the following example when creating a new page:

  1. On the Workspace home page, click the App Builder icon.

  2. Select an application.

  3. Click Create Page.

  4. Click Chart.

  5. Select Map Chart.

  6. For Map Type, select United States of America and click Next.

  7. For Map Source, expand Country Maps and select States.

    Description of map_chart1.png follows
    Description of the illustration map_chart1.png

  8. For Page Attributes specify the appropriate attributes and click Next.

  9. For Navigation Preference, specify the type of navigation to include on this page and click Next. The navigation options (for example, navigation menu or tabs) depends upon the current application theme.

  10. For Map Attributes, select the appropriate attributes and click Next.

    The Query page appears.

  11. Scroll down and expand and review the Map Query Example and Map Reference Information regions.

  12. Scroll down and expand and review the Map Reference Information region at the bottom of the page.

    Description of map_chart2.png follows
    Description of the illustration map_chart2.png

    Specify a SQL query by either:

    • Entering a SQL query in the field provided. See "About Creating SQL Queries for Maps."

    • Clicking the Build Query button. When the Build Chart Query Wizard appears, follow the on-screen instructions.

    When you create your query, you must incorporate the region name information as described in the Map Reference Information region. The following example includes information for Florida and Alaska: 

    SELECT null link, region label, value Populations
FROM (
SELECT 'Florida' region, 18328340 value FROM dual
UNION ALL
SELECT 'Alaska' region, 686293 value FROM dual)

    Note:

    If you are referencing geographical information stored in a database table, the information must correspond with the Region information associated with the map source. For more information, see AnyChart User's Guide: http://6.anychart.com/products/anymap/docs/

    Click Create.

Parent topic: Creating Legacy Maps

25.4.3 Adding a Legacy Map Chart to a New Page

Add a map chart to a page by running the Create Page Wizard.

To add a map chart on a new page:

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
  3. Click Create Page.
    The Create Page Wizard appears.
  4. On Create a Page:

    1. User Interface - Select a user interface for the page.

      This attribute only displays for applications using older themes and for which Desktop and Mobile User Interfaces have been defined.

    2. Select a page type - Select Legacy Page and then select Map Chart.

  5. On Map, select a map type (for example, Europe), and click Next.
  6. On Map Source, expand the tree and select the map to create.
  7. For Page Attributes:
    1. Page Number - Select a page in which the chart object is to appear.
    2. Page Name - If creating a new page, enter a page name.
    3. Page Mode - Select a page mode.
    4. Breadcrumb - Select whether you want to use a breadcrumb navigation control on your page, and which breadcrumb navigation control you want to use
    5. Click Next.
  8. On Navigation Menu, specify a Navigation Preference and click Next.
  9. For Map Attributes, select the appropriate attributes and click Next.

    Note:

    To learn more about an attribute, see field-level Help.

  10. Specify a query by either:
    • Entering a SQL query in the field provided.
    • Clicking the Build Query button. When the Build Chart Query Wizard appears, follow the on-screen instructions.

    Specify relevant attributes. To view map reference information associated with your selected Map Source, expand the Map Reference Information region at the bottom of the page.

    To associate data with geographical locations, you must incorporate information from the Region Name or Region ID columns into the Map query.

  11. Click Create.

See Also:

"About Creating SQL Queries for Maps"

Parent topic: Creating Legacy Maps

25.4.4 Adding a Legacy Map Chart in Page Designer

Add a map chart by manually creating it in Page Designer.

To add a map chart to an existing page.

  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. In the Gallery at the bottom of the page:
    1. From the Gallery Menu, select Show Legacy Components.
    2. Right-click Map Chart region, select Add To, and select the appropriate location.

    Tip:

    You can also select the Map Chart [Legacy] region and drag it to the appropriate location in the Layout tab.

  3. 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.
  4. In the Property Editor Region tab, edit the following attributes:

    To learn more about an attribute, select the attribute in the Property Editor and click the Help tab in the center pane.

    1. Title - Enter a title for the region.

    2. Layout:

      • Sequence - Enter the display sequence for this item.

      • Parent Region - Select the parent region to which this region belongs.

      • Position - Select the template position used to display this region.

    3. Appearance:

      • Template - Select a region template.

      • Item Display Position - Specify where page items display in relation to the main region content.

    4. Layout - Specify the Sequence, Parent Region, and Position.

    5. Appearance - Specify the template.

  5. View the Map Chart attributes. In the Property Editor, select the Attributes tab.

    In the Property Editor, edit the following Map attributes:

    1. Map, Level 1 - Select the map level from the available list (for example Europe).

    2. Map, Level 2 - Select the map level from the available list (for example, Denmark).

    3. Source, SQL Query - Enter the SQL Query for the chart series.

    4. Edit other attributes as appropriate.

      Tip:

      To learn more about an attribute, select the attribute in the Property Editor and click the Help tab in the center pane.

  6. Click Save.

Parent topic: Creating Legacy Maps