APEX

Hello,

following instructions for map chart creation through an APEX tutorial i created a map chart that was suppossed to show total sales for some european countries. However when i ran the page the map of Europe continent appeared without any labels and colors for the countries returned by the map's series sql as it should be. I doubled checked all steps for map's creation many times and found no error in the process. My next step was to search on the internet for a possible solution but found nothing relevant. After many hours of research i visited http://www.anychart.com/products/anychart/mapList/World-World-and-Continent-Maps-Europe-Flash-Map.html and noticed while hovering the mouse over countries that their names were camel-cased. So, i changed the select statement of map's series like this : "SELECT NULL LINK, INITCAP(COUNTRY), SUM(SALES) FROM SALESDATA GROUP BY COUNTRY" and map finally worked as expected. Country names in my SALESDATA table are all stored in uppercase. I think this is not a normal behavior and should work not taking in to account the case of country names. I just wanted to share my experience on this issue hoping to help others facing a similar situation and for a fix in a future release.


APEX version installed : 4.2.1.00.08 on Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production