The Query Manager component of Smart Map allows you to select data from any database. With this data, you can plot points and also fill each marker's balloon window.
How it works
In the Balloon Template box of Query Manager, wrap column names in double square brackets like this: [[columnname]]. The "columnname" must correspond to a column in the data set that is generated from your custom query.
At runtime, Smart Map and replaces all [[columnname]] identifiers in the balloon template with actual field data.
 If you use a wildcard in your select statement, such as "SELECT * FROM JetkeyCountry" then you can use any field from that table in your balloon template. |
Example
SELECT * FROM JetkeyCountry WHERE Latitude IS NOT NULL
The JetkeyCountry table has the following columns: CountryCode, Country, Latitude and Longitude
Any of these column names can be used in the Balloon Template.
Click to enlarge
| If you use alias column names, such as Select FirstName+LastName as FullName from MyTable..., you can use the alias [[FullName]] in your Balloon Template. |