Bug report #19100

WFS request with combined filter (BBOX + PropertyIsEqual) not working

Added by Andreas Steffens about 2 years ago. Updated almost 2 years ago.

Status:In Progress
Priority:Normal
Assignee:-
Category:QGIS Server
Affected QGIS version:3.0.3 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:26930

Description

I'm having problems getting a WFS request using a filter with two conditions (BBOX + PropertyIsEqual) to work with QGIS Server. My goal is to get all features within a certain area that have an attribute with a certain value. Sounds simple enough.

http://localhost:8081/cgi-bin/gis.server?service=WFS&request=GetFeature&version=1.1.0&map=C:\OSGeo4W\var\qgis\gis\overview.qgs&srsname=EPSG:3857&typename=projects&outputformat=geojson&filter=&lt;Filter&gt;&lt;And xmlns="http://www.opengis.net/ogc"><Or><PropertyIsEqualTo><PropertyName>id</PropertyName><Literal>8</Literal></PropertyIsEqualTo><PropertyIsEqualTo><PropertyName>id</PropertyName><Literal>9</Literal></PropertyIsEqualTo></Or><BBOX><PropertyName>geometry</PropertyName><Envelope xmlns="http://www.opengis.net/gml" srsName="EPSG:3857"><lowerCorner>1501468.311742801 6893026.717014579</lowerCorner><upperCorner>1505075.184015008 6896901.1188857835</upperCorner></Envelope></BBOX></And></Filter>

QGIS Server always returns an empty feature set on the combined request. Running separate requests with only a single filter condition however returns the correct results. I'm unsure as to whether my filter syntax is somehow wrong or QGIS Server doesn't support logical operators at all. Any help or fix would be appreciated!

History

#1 Updated by René-Luc ReLuc about 2 years ago

A PR has been merged in 3.2 and probably fixed it.
https://github.com/qgis/QGIS/pull/7007

Can you test it ?

#2 Updated by Arnaud Morvan almost 2 years ago

Pull Request 7007 fix SRS issue only for the case BBOX is direct child of an And, itself direct child of the Filter Element, which may be a common case in a GetFeature request.

#3 Updated by Andreas Steffens almost 2 years ago

Yes ... i can confirm that 7007 fixes the issue under the condition mentioned by Arnaud.

#4 Updated by Alessandro Pasotti almost 2 years ago

  • Status changed from Open to In Progress

Is this now fixed in master?

Also available in: Atom PDF