Restrict display of polygons in a feature layer using a data link? Geocortex Essentials.
I have a feature layer of polygons that represents all the plots of 4 cemeteries, and a data connection to a non spatial data table on SQL Server with the details of each plot.
I want to display the layer twice, once with all the plots by section (I have done this via data link), and a second time as an overlay to this layer just showing the plots that are 'reserved'.
Is it possible to only display those polygons of the feature layer where the 'is_reserved' field of the non spatial table = "Y"? i.e. use a data link as a sort of INNER JOIN?
I'm just looking for a way to keep the data as live as possible. You can imagine it is a sensitive topic!
-
I don't think this is possible.
You could use a layer filter workflow. In this workflow you should query your non spatial table (SQL Query activity) to get a list of IDs for which is_reserved = "Y". This list you should as where clause (e.g. ID IN (1,2,10))
Disadvantage of this approach is for each map image request a query is sent to the database.
0
Please sign in to leave a comment.
Comments
1 comment