[mapguide-users] Building an intelligent tooltip

[Campbell, Keith A]

Have you tried creating a view/query in the ODBC database itself and
mapping it? I understand version 1.2.0 will read views.

Keith

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of uXuf
Sent: 20 November 2007 01:19
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Building an intelligent tooltip


Hi guys,

I am trying to build a tooltip that contains data from multiple tables
(essentially - a join). I have a point layer that gets populated from an
ODBC source. The table has a relatively simple structure: PointID,
PointName, PointLat, PointLon and PointTypeID. Now this PointType is a
foreign key into a Types table which contains only the TypeID and
TypeName fields. What I'd like is the tooltip to resolve the PointTypeID
and get the TypeName to display.

I tried feature-joining the ODBC Source with itself (figures since both
the tables are in the same db), and created a new Extended class (named
PlaceType). This extended class has its primary feature class as the
Points table (or Default:points) and the secondary feature class as the
Types table (Default:types). I then specified for join the PointTypeID
column and the TypeID column.

Now when I reselect the feature source (in an effort to update the
Feature Class dropdown list) I DO get the Default:PlaceType class, but
if I select it I lose all my geometry fields. This extended class
apparently does not pick up the Lat and Lon columns from the original
tables, it only picks up the PointID and PointName columns. So basically
in an effort to get a join I lose my geometry fields.

Any insights into this or would I have to add *yet* another layer with
only tooltips and no points?

Probably a better solution would be to allow SQL type expressions in the
expression builder, a bit reminiscent of MG 6.x.

Regards,
uXuf
--
View this message in context:
http://www.nabble.com/Building-an-intelligent-tooltip-tf4840591s16610.ht
ml#a13849076
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users


This message has been scanned for viruses by MailControl - (see
http://bluepages.wsatkins.co.uk/?6875772)


This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.

The ultimate parent company of the Atkins Group is WS Atkins plc.  Registered in England No. 1885586.  Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW.

Consider the environment. Please don't print this e-mail unless you really need to.