I am seeing some behavior that seems off from what I understand should be happening with the WPS.
Using a PostGIS data store, If I make a WFS GetFeature query, and watch the Postgres logs with log_statement "all" I can see the WHERE clause properly constructed in the query to the database: Example: http://localhost:8888/geoserver/ows?service=wfs&version=1.1.0&request=GetFeature&TYPENAME=country_boundaries&cql_filter=iso_a2='US'&maxfeatures=10 produces a SQL query like this: SELECT "gid",encode(ST_AsEWKB("geom"), 'base64') as "geom","... FROM "ne_50m_admin_0_countries_lakes" *WHERE ("iso_a2" = 'US' AND "iso_a2" IS NOT NULL )* LIMIT 1000000 However, If I use the WPS gs:Query process in the same manner with CQL: <?xml version="1.0" encoding="UTF-8"?><wps:Execute version="1.0.0" service="WPS" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns="http://www.opengis.net/wps/1.0.0"; xmlns:wfs="http://www.opengis.net/wfs"; xmlns:wps="http://www.opengis.net/wps/1.0.0"; xmlns:ows="http://www.opengis.net/ows/1.1"; xmlns:gml="http://www.opengis.net/gml"; xmlns:ogc="http://www.opengis.net/ogc"; xmlns:wcs="http://www.opengis.net/wcs/1.1.1"; xmlns:xlink="http://www.w3.org/1999/xlink"; xsi:schemaLocation="http://www.opengis.net/wps/1.0.0 http://schemas.opengis.net/wps/1.0.0/wpsAll.xsd";> <ows:Identifier>gs:Query</ows:Identifier> <wps:DataInputs> <wps:Input> <ows:Identifier>features</ows:Identifier> <wps:Reference mimeType="text/xml" xlink:href="http://geoserver/wfs"; method="POST"> <wps:Body> <wfs:GetFeature service="WFS" version="1.0.0" outputFormat="GML2" xmlns:ngs="http://newmoyergeospatial.com";> <wfs:Query typeName="ngs:country_boundaries"/> </wfs:GetFeature> </wps:Body> </wps:Reference> </wps:Input> <wps:Input> <ows:Identifier>filter</ows:Identifier> <wps:Data> <wps:ComplexData mimeType="text/plain; subtype=cql"><![CDATA[iso_a2='US']]></wps:ComplexData> </wps:Data> </wps:Input> </wps:DataInputs> <wps:ResponseForm> <wps:RawDataOutput mimeType="application/json"> <ows:Identifier>result</ows:Identifier> </wps:RawDataOutput> </wps:ResponseForm> </wps:Execute> I see a SQL query like this: SELECT "gid",encode(ST_AsEWKB("geom"), 'base64') as "geom", ... FROM "ne_50m_admin_0_countries_lakes" LIMIT 1000000 Its missing the *where clause* so presumably post filtering is happening in memory, which is not ideal. And in some cases a deal breaker. Bug? Any workarounds to try? So far have tried using vec:Query, and tried using XML filters vs CQL. Same results. Thanks. Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 ja...@newmoyergeospatial.com
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
