Attribute table don't filter data with view port

[Cristian Apostol]

Hello,

My layers are stored in a Microsoft SQL Server database, when I'm opening the attribute table for a layer, for example ''tgNradm',  I can see all the records that are stored in that table (table1.png).

The problem appears when I'm trying to Filter data by the current viewport. When I try to move around or refresh the application the table stays empty (table2.png).

[Lorenzo Natali]

Hi,

This may be related with https://groups.google.com/g/mapstore-users/c/WC60oQJXvKw

I'm trying to guess a little bit, but in widgets there is a geometric filter too.

Maybe the integration with GeoServer and  Microsoft SQL Server has some issue. 

If you are able to copy the request of the WFS table that fails, you  can look for some existing known issue, or you can ask to the GeoServer's community some help

[Cristian Apostol]

I found the solution🎉

When you import a .shp into the SQL Server database, the imported file does not come with an SRID (the projection is not defined). To fix this you need to specify manually the SRID code

After that, you need to create a table using this script:

CREATE TABLE GEOMETRY_COLUMNS( F_TABLE_SCHEMA VARCHAR(30) NOT NULL, F_TABLE_NAME VARCHAR(30) NOT NULL, F_GEOMETRY_COLUMN VARCHAR(30) NOT NULL, COORD_DIMENSION INTEGER, SRID INTEGER NOT NULL, TYPE VARCHAR(30) NOT NULL, UNIQUE(F_TABLE_SCHEMA, F_TABLE_NAME, F_GEOMETRY_COLUMN), CHECK(TYPE IN ('POINT', 'LINESTRING', 'POLYGON', 'MULTIPOINT', 'MULTILINESTRING', 'MULTIPOLYGON', 'GEOMETRYCOLLECTION') ));

In this table you need to insert:
F_TABLE_SCHEMA - dbo in most cases

F_TABLE_NAME  - name of your table

F_GEOMETRY_COLUMN - column where is stored geometry in your table

COORD_DIMENSION -  2 is for coordinates that contain X,Y    -   3 is for coordinates that contain X,Y,Z  

SRID - 3844 (EPSG code)

TYPE  - POINT (or LINESTRING, POLYGON, etc)

After that you need to go GeoServer and set up the connection to your database, and in the bottom of the page you need to specify the geometry table (see the photo that is attached)

After all these steps you will be able to query your data and also to make a widget from your data.

[Lorenzo Natali]

Great to know,

thank you for sharing, 

this is very useful for users with the same problem.

And thank you for using MapStore.