Plot locations around a target or central location
The extension also allows users to plot locations that lie within a certain radius from a central location. This can be done by adding parameters to the formula that enable the extension to find the central location and set the radius:
QB_DBIDR—The DBID of the table from which the extension queries the central location.
clistR—Ordered list of field IDs required to plot the central location on the map.
queryR—Filter condition used by the extension to get the central location.
rad—Radius (in miles) around the central location within which the markers should lie.
dist—Users can set the value of this parameter to either Y or N. This parameter is used along with the rad parameter (see above) and toggles the radius feature on or off.
Note
This table should return only 1 location, since it is the central location. Make sure to pass an appropriate filter condition in the queryR parameter.
Users can query data from multiple tables (with database IDs passed in as QB_DBID1, QB_DBID2, and so on) and plot only those locations that lie within a certain distance from a location retrieved from the QB_DBIDR table. For example, a Formula URL that queries one table (QB_DBID1) and sets a 5-mile radius around a central location (QB_DBIDR) looks like:
//first portion is the contacts surrounding the target
//second portion is the target contact
"http://your-server/Juiced/QB Maps/qbmaps.aspx?" // your QB Maps server URL, created by the setup wizard
& "&clientid=Q2"
& "&appid=bdtmpnmx5"
& "&QB_DBID1=bdtmm652j"
& "&query1={'10'.EX.'Nassau'}OR{'10'.EX.'Suffolk'}"
& "&clist1=3.21.22.26.27.25.8.11.9.23.$20.N13.N16"
& "&QB_DBIDR=" & Dbid() // central/radius location
&"&queryR={'3'.EX.'" & [Record ID#] & "'}"
& "&clistR=3.14.15.6.16.7.8.9.10.17.11.12.13"
& "&dist=y"
& "&rad=5"The last five lines (QB_DBIDR, queryR, clistR, dist, rad) are what add the central/radius location on top of the regular table query.