Skip to Main Content

Report Map

Flex Fields

Click a pin to get data about it, including the values for up to 10 "flex fields" that were supplied in the query. This example generates random 3-character strings.

Query for map plugin: select c003 as lat, c004 as lng, c002 as name, c001 as id ,c002 || ' (id=' || c001 || ')' as info ,c009 as attr01 ,c010 as attr02 ,c011 as attr03 from apex_collections where collection_name = 'MAP'

When a pin is clicked, a dynamic action on the markerClick event gets the details for the pin, including the ten flex fields. It has an Action, Set Value on P17_DATA, with JavaScript Expression: "this.data.attr01=" + this.data.attr01 + " this.data.attr02=" + this.data.attr02 + " this.data.attr03=" + this.data.attr03

Source data

-17.960934122.212257Cable Beach10Cable Beach (id=10)hyVWuAHcD
-24.884879113.656654Carnarvon9Carnarvon (id=9)CigqZsZic
-31.181378117.380332Wyalkatchem3Wyalkatchem (id=3)WHZUrMPap
-31.824755115.739808Hillarys Boat Harbour11Hillarys Boat Harbour (id=11)KEWQVwpTp
-31.869722116.034851Stratton2Stratton (id=2)iPUWmFVIC
-31.958206115.864348boss's office4boss's office (id=4)kreNduSKt
-31.998759115.538063Rottnest Island6Rottnest Island (id=6)kNLZdZvJo
-32.013843116.001141Wattle Grove5Wattle Grove (id=5)vMxXAUUHp
-32.116202116.065471home1home (id=1)XWbovxRwE
-32.123472116.101037Araluen Botanical Park13Araluen Botanical Park (id=13)oLEYkjpuD
-32.441371118.89739Wave Rock12Wave Rock (id=12)ItBamrfsA
-33.645277115.34254Busselton7Busselton (id=7)mCjVXONrI
-33.852597121.897087Esperance8Esperance (id=8)HMcbRbbxc
0.00.0Null Island14Null Island (id=14)PQwvpyZJB