Ticket #3205 (closed enhancement: fixed)

Opened 4 years ago

Last modified 3 years ago

OFC filter: propertly like should be converted to sql expression for db layers

Reported by: assefa Owned by: assefa
Priority: normal Milestone: 6.0 release
Component: WFS Server Version: unspecified
Severity: normal Keywords: OFC filter propertyislike
Cc: bartvde

Description

Right now when a filter encoding contains multiple PropertyIsLike? operations, it use MapServer class expressions to do the queries. But in some cases, we could converted them sql expression for db layers.

Change History

Changed 4 years ago by assefa

  • cc bartvde added
  • keywords filter added; filer removed

Here is an example of expression that should use sql expression for db layers:

<wfs:GetFeature xmlns:wfs="http://www.opengis.net/wfs" service="WFS" version="1.1.0" maxFeatures="100" xsi:schemaLocation="http://www.opengis.net/wfs  http://schemas.opengis.net/wfs/1.1.0/wfs.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><wfs:Query typeName="feature:HISTOMAP_NL_1799_English_Admiralty_region" srsName="EPSG:4326" xmlns:feature="http://mapserver.gis.umn.edu/mapserver"><wfs:PropertyName>LEGEND</wfs:PropertyName><wfs:PropertyName>NAME</wfs:PropertyName><ogc:Filter xmlns:ogc="http://www.opengis.net/ogc"><ogc:Not><ogc:PropertyIsLike wildCard="*" singleChar="." escape="!"><ogc:PropertyName>LEGEND</ogc:PropertyName><ogc:Literal>*open*</ogc:Literal></ogc:PropertyIsLike></ogc:Not></ogc:Filter></wfs:Query></wfs:GetFeature>

Changed 3 years ago by assefa

This issue should be solved with the correction of #2720

Changed 3 years ago by assefa

  • status changed from new to closed
  • resolution set to fixed
Note: See TracTickets for help on using tickets.