In geoserver only geometry type of SQL server table is detected. Which means SLD style can't be applied ogc filter tag. But none of my SQL server field beside geometry are detected by geoserver. How can I do that ?
Create table script
CREATE TABLE My_GIS_Table
(
LOCALNAME varchar(50),
Coord geometry not null,
constraint PK_My_GIS_Table primary key (LOCALNAME)
)
SLD created with uDig from a shapefile.
<sld:Rule>
<sld:Name>MY_CITY_NAME</sld:Name>
<ogc:Filter>
<ogc:PropertyIsEqualTo>
<ogc:PropertyName>LOCALNAME</ogc:PropertyName>
<ogc:Literal>MY_CITY_NAME</ogc:Literal>
</ogc:PropertyIsEqualTo>
</ogc:Filter>
<sld:PolygonSymbolizer>
<sld:Fill>
<sld:CssParameter name="fill">#E31A1C</sld:CssParameter>
<sld:CssParameter name="fill-opacity">0.45</sld:CssParameter>
</sld:Fill>
<sld:Stroke>
<sld:CssParameter name="stroke-dashoffset">5</sld:CssParameter>
<sld:CssParameter name="stroke-dasharray">2.0</sld:CssParameter>
</sld:Stroke>
</sld:PolygonSymbolizer>
</sld:Rule>
Hypothetic SLD I'd like to create for my SQL Server table
Here I just want to change the part with tags. With something posibly like tags. Ogc tags and Geoserver wont recognize MY_GIS_TABLE
field name LOCALNAME
so I don't know how to edit the existing SLD to create a filter upon that field.
<MSSQL:Filter>
<MSSQL:PropertyIsEqualTo>
<MSSQL:PropertyName>LOCALNAME</MSSQL:PropertyName>
<MSSQL:Literal>MY_CITY_NAME</MSSQL:Literal>
</MSSQL:PropertyIsEqualTo>
</MSSQL:Filter>