jeffreykemp / jk64-plugin-reportmap

Report Google Map APEX Plugin
https://jeffreykemp.github.io/jk64-plugin-reportmap/
MIT License
42 stars 16 forks source link

Errors on lat/long <1.000 and circle radii >999 #42

Closed jeffreykemp closed 6 years ago

jeffreykemp commented 6 years ago

Hi Jeff,

I am using your excellent Report Map plugin and have found a few issues that hopefully you may be able to resolve.

Firstly, any Latitudes or Longitudes which are less than 1 in number format cause an error as they are processed as “.XXX” rather than “0.XXX”. Obviously the “to_char” function can be used as a work around to insert a zero before the decimal point, but it may be worth trapping that possibility, or updating the documentation to make the preferred data type explicit.

Secondly, circles with a radius less than 1 in number format cause an “Error in PLSQL code raised during plug-in processing.” error which is possibly the same type of issue as described above.

Finally, circles with a radius greater than 999 in number or text format generate a “Error: SyntaxError: JSON.parse: unexpected character at line XXX column YYY of the JSON data” error.

Many thanks,

Rod.

jeffreykemp commented 6 years ago

Fixed in 0.9