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: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of uXuf > Sent: 20 November 2007 01:19 > To: [email protected] > 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 > [email protected] > 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 > [email protected] > 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. _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
