Opened 14 years ago

Closed 14 years ago

#3205 closed enhancement (fixed)

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 (3)

comment:1 by assefa, 14 years ago

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>

comment:2 by assefa, 14 years ago

This issue should be solved with the correction of #2720

comment:3 by assefa, 14 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.