[Geoserver-devel] [JIRA] (GEOS-9131) Multiple SortBy Expressions WFS query with nested filter fails on App-schema SQL

[JIRA]

Title: Message Title

Fernando Miño created an issue   GeoServer / GEOS-9131 Multiple SortBy Expressions WFS query with nested filter fails on App-schema SQL Issue Type: Bug Assignee: Unassigned Components: Application schema Created: 24/Feb/19 6:10 PM Priority: Medium Reporter: Fernando Miño Executing a WFS query with nested filter and multiple sortBy expressions throws an malformed SQL exception on App-schema and Postgresql. For example this WFS Query executed on Stations example data: <wfs:GetFeature service="WFS" version="2.0.0" xmlns:st="http://www.stations.org/1.0" xmlns:wfs="http://www.opengis.net/wfs/2.0" xmlns:fes="http://www.opengis.net/fes/2.0" xmlns:gml="http://www.opengis.net/gml/3.2"> <wfs:Query typeNames="st:Station" srsName="EPSG:4326"> <fes:Filter> <fes:PropertyIsLike wildCard="*" singleChar="." escapeChar="\"> <fes:ValueReference>st:Station/st:observation/st:Observation/st:description </fes:ValueReference> <fes:Literal>*</fes:Literal> </fes:PropertyIsLike> </fes:Filter> <fes:SortBy> <fes:SortProperty> <fes:ValueReference>st:Station/st:stationName</fes:ValueReference> <fes:SortOrder>DESC</fes:SortOrder> </fes:SortProperty> <fes:SortProperty> <fes:ValueReference>st:Station</fes:ValueReference> <fes:SortOrder>ASC</fes:SortOrder> </fes:SortProperty> </fes:SortBy> </wfs:Query> </wfs:GetFeature> Throws a Postgresql exception: ERROR: syntax error at or near "FROM" at character 504 Add Comment   Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100098-sha1:60b0277)

_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel