VERIFIED SOLUTION i
Map fails to zoom to selected row in query result in Spectrum Spatial Analyst
Issue
In SSA connect page, create and run a query.
In the results panel, click on any row.
SSA fails to zoom to selected row i.e map does not move to the selected object
In the results panel, click on any row.
SSA fails to zoom to selected row i.e map does not move to the selected object
Cause
This is a bug in SSA. Zoom to selection fails in two scenarios.
1) When data contains a column named "id". The name 'id' conflicts with the name that SSA uses as a primary key to identify the record. The zoom to selected row fails in that case since this action needs a primary key value.
2) When using SQL views for map layers
1) When data contains a column named "id". The name 'id' conflicts with the name that SSA uses as a primary key to identify the record. The zoom to selected row fails in that case since this action needs a primary key value.
2) When using SQL views for map layers
Resolution
UPDATED: November 27, 2017This issue will be fixed in SSA 13
Bug reference numbers:
CONN-35022 - Zoom to query selection doesn't work when we use an sql view
CONN-34870 - Query result is not highlighted on map if table has a column with name 'id'
Workaround is to rename any columns named id to something else and re-upload the data via map uploader.
No workaround available when using SQL views.
Bug reference numbers:
CONN-35022 - Zoom to query selection doesn't work when we use an sql view
CONN-34870 - Query result is not highlighted on map if table has a column with name 'id'
Workaround is to rename any columns named id to something else and re-upload the data via map uploader.
No workaround available when using SQL views.
Environment Details
