[Geoserver-users] How to create SQL Views with Prepare Stamts with parameters

GeoServer GeoServer User
1

Hello,

I’m trying to work with Layers with SQL Views. I already know how to create SQL Views with parameters, but I’m trying to add something else.

The aim is to create SQL queries where is possible to ignore conditions in the Where clause. For example, if the parameter for the first condition is NULL, the parameter should be ignored.

I’ve created the query and it works on PostgreSQL, but I’d like to see some examples in GeoServer.

I’d appreciate any help.

Thanks!

Regards,

Dominique.