I have published point file in geoserver from postgis table as store. I had huge data in my table(rows) and the data will keep udate daily (at least one point for one day). Now I want to show only the last 10 points added.

How do I restrict the data using Geoserver SLD Function?

1 Answer 1


Personally, I would try to separate data store access/publishing from layer styling.
You could create a SQL View for the datastore, effectively adding a new layer with the query result table. The query will execute each time the layer is requested, the SLD style can be applied as usual.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.