Re: [mapguide-users] SQL Server Spatial View Selection Issue

Maestro has something like that already for the ODBC Feature Source editor. It just has to be made more generic so it can be retrofitted into the RDBMS editors. - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Spatial-View-Selection-Issue-tp5228068p52289

Re: [mapguide-users] SQL Server Spatial View Selection Issue

Yeah, it's really a good way to manage what tables you would like MapGuide/AIMS to access. I am going to improve the performance of our municipal GIS by using FDO Toolbox. Moreover, I think it will be a great idea if Maestro or Infrastructure Studio will not only allow user to pick only the tables

Re: [mapguide-users] SQL Server Spatial View Selection Issue

Note that configuration documents are also a nice attack surface reduction and performance improvement measure as you're telling MapGuide *what* your data store structure is like instead of letting the FDO provider find out for itself. If you describe the schema of a configured feature source, it

Re: [mapguide-users] SQL Server Spatial View Selection Issue

Hi Jakie, Thank you for your reply, and I modified the config.xml that export from one of my SQL Server DB. I only left three SQL Server Spatial View in the config.xml, and I paste the content of the config.xml back to AIMS SQL Server feature source configuration document by using Maestro, and it

Re: [mapguide-users] SQL Server Spatial View Selection Issue

If you just whittled down the schema override to just that one view feature class and export out that configuration from FDO Toolbox, does it work? - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Spatial-View-Selection-Issue-tp5228068p5228393.html Sent

Re: [mapguide-users] SQL Server Spatial View Selection Issue

Hi Jackie, Thank you for your reply :) Firstly, I have two databases on my SQL Server. One of them, I was not able to export Data Store Configuration to XML for it. It showed me the error as following screen capture: Secondly, fo

Re: [mapguide-users] SQL Server Spatial View Selection Issue

If you have access to the database you can also recreate your view as an "Indexed View". Only requirement is that you create your view with "schemabinding": Next, you can create a unique index on this view: Afterwards you should be able to select features on your layer. Gunter -- View thi

Re: [mapguide-users] SQL Server Spatial View Selection Issue

Have you tried overriding the FDO schema of the SQL Server feature source to force an identity property on the view feature class? http://themapguyde.blogspot.com.au/2010/08/using-fdo-schema-overrides.html - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Serve

[mapguide-users] SQL Server Spatial View Selection Issue

Hello everyone, Does anyone know how to make AIMS allow users to select the feature from spatial view on SQL Server? Since the sql server spatial view doesn't have primary key, but I think it will be nice if AIMS can still allow user to spatially select the features. I am using AIMS 2014, and