[mapguide-users] Building an intelligent tooltip

[uXuf]

I am using version 1.1. Isn't it so that I am missing something in the steps
I am taking? Or is it that I do not have such luxury in 1.1?

uXuf


Keith Campbell wrote:
> 
> 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. 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/Building-an-intelligent-tooltip-tf4840591s16610.html#a13866710
Sent from the MapGuide Users mailing list archive at Nabble.com.