Skip to Main Content

Report Map

Table or View

The map region has Source Type set to Table / View, with the source table JK64DEMO_COUNTRIES_VW.

The view is defined on the database as:

create view jk64demo_countries_vw as
select lat, lng, country as name, rowid as id
from jk64demo_countries sample(10)
where lat is not null and lng is not null

Using this source type requires that the source table or view provide columns with the right names. The columns required depend on what Visualisation is chosen. Look at the Source Help within APEX for more information.

Not all features, such as popup info windows and pin labels, are supported in this mode; for additional features, use the SQL Query or PL/SQL Function returning SQL Query source type instead.