Wrong tooltip showed

[mphaneuf]

In MGOS 2.1, we have a road layer with the name of the road as tooltip. The problem is that the wrong tooltip pop-ups when we hover a road from this layer. The tooltip that appears comes from a layer based on a view (created with joined tables) representing the owner of a parcel, which is next to the road.

As you can see on the attached PNG (where the mouse cursor is the black dot), even though my cursor in hovering a road, the tooltip that pop-upped is coming from the owner layer.

We have made some tests and this only happens with layers based on views created with joined tables.

The database is SQL Server 2008 r2.

[mphaneuf]

Wrong tooltip example

[zspitzer]

Is this with the AJAX Viewer?

Do you mean your are authoring off a view with databases joins? If so the view must present a Primary Key, just like a normal table, otherwise it does cause problems.

I know this can be done in Oracle (i.e create a primary key on a view) but you will need to investigate how to do this in Sql Server

In the future, please post to the mailing list before filing an issue in trac

[jng]

Views by default will probably not have an identity property, which will throw any sort of spatial query (selection/tooltip) into disarray.

Use FDO schema overrides to apply identity properties:

• ​http://themapguyde.blogspot.com.au/2010/08/using-fdo-schema-overrides.html
• ​http://themapguyde.blogspot.com.au/2010/09/using-fdo-schema-overrides-redux.html