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 , 14 years ago
Cc: | added |
---|---|
Keywords: | filter added; filer removed |
comment:3 by , 14 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
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>