Why not do the join in a database view? Then let Mapguide use the view for display?
Martin Morrison Infrastructure Application Engineer/Systems Analyst Engineering Design Systems, Inc. 540.345.1410 martin.morri...@edsi.com www.edsi.com -----Original Message----- From: mapguide-users [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of Liglio Sent: Wednesday, January 3, 2018 6:39 PM To: mapguide-users@lists.osgeo.org Subject: [mapguide-users] Display Historival value assigned to a polygon I am trying to display historical info about States of a Country. I have two tables: State (State ID, State Name, Geometry) and State Power Load (State ID, Date/Time, Power Observed, Power Predicted). To show a State color themed layer based on the deviation of Observed and Predicted, I need to join these two tables in a single one table (State ID, State Name, Date/Time, Power Observed, Power Predicted, Geometry). This solution will lead to a large table due to the geometry of the State to be in each row (so, I don't like it). Another solution is to join two tables using mapguide, but I already tried some years ago and it did not work (Postgresql database). What is the best approach to solve this problem ? -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
