About Creating SQL Queries for Maps

You define a map in Application Builder using a wizard. For most chart wizards, you select a map type, map source, and provide 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 that you wish to associate data with. The Region ID or Region Name of the map should 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 Application Builder icon.

2. Select an application.

3. Click Create Page.

4. Select Map and click Next.

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

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

   
   Description of the illustration maps_source1.gif
   
   

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

8. Specify whether to include tabs and click Next.

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

   The Query page appears.

10. Expand and review the Map Region Information region at the bottom of the page.

    
    Description of the illustration maps_source2.gif
    
    

11. For Query,

    1. Specify a 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.

    2. When you create your query, you must incorporate the region name information. 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://anychart.com/products/anymap/docs/

       
       

    3. Click Next.

12. Click Finish.