Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Generate JavaScript array of objects from Interactive report column values

Robert SibekMar 20 2019 — edited Mar 21 2019

Hello,

I have an interactive report on page with GPS coordinations

Based on current filters I need to show listed locations on Google maps as markers.

pastedImage_0.png

My Idea is to call DA after refresh to generate JavaScript array or directly the JS function to show marker on Map.

So I'd probably need to dynamically create something like this:

  var deviceLocations \= \[        \['[37AB2C](http://vpson/apex/f?p=100:5:14442614769943::NO:RP:P5_DEVICE,P5_LATITUDE,P5_LONGITUDE:37AB2C,55.755825,37.617298)', \-33.890542, 151.274856, 4\],        \['[37AB2D](http://vpson/apex/f?p=100:5:14442614769943::NO:RP:P5_DEVICE,P5_LATITUDE,P5_LONGITUDE:37AB2C,55.755825,37.617298)', \-33.923036, 151.259052, 5\],        \['[37AB2A](http://vpson/apex/f?p=100:5:14442614769943::NO:RP:P5_DEVICE,P5_LATITUDE,P5_LONGITUDE:37AB2C,55.755825,37.617298)', \-34.028249, 151.157507, 3\],        \[[37AB3C](http://vpson/apex/f?p=100:5:14442614769943::NO:RP:P5_DEVICE,P5_LATITUDE,P5_LONGITUDE:37AB2C,55.755825,37.617298)', \-33.80010128657071, 151.28747820854187, 2\],        \['[37CB2C](http://vpson/apex/f?p=100:5:14442614769943::NO:RP:P5_DEVICE,P5_LATITUDE,P5_LONGITUDE:37AB2C,55.755825,37.617298)', \-33.950198, 151.259302, 1\]      \];

And then iterate through the array to setup Markers.

Unfortunately I have no currently idea how to create this array dynamically.

Thanks in advance for your helpful suggestions.

Kind regards,

Robert
This post has been answered by Robert Sibek on Mar 21 2019
Jump to Answer
Comments
Post Details
Added on Mar 20 2019
#apex, #apex-discussions, #javascript
5 comments
1,417 views