There is ticket on this : http://trac.osgeo.org/mapserver/ticket/2075. I
have fixed the ilike to be only done for postgis layers. I will wait
for Sture answer to see if something has to be done for the escape
statement.
Later,
Bart van den Eijnden (OSGIS) wrote:
Hi Sture,
if you leave out matchCase='false' in your filter ilike will turn into like.
But you should file a bug about this, since ilike is for PostgreSQL. But at
least you've got a workaround for now.
I believe there is nothing wrong with escape '!', it should be there in case
someone wants to escape a character in the search string. Does it not run in
sqlplus? If so, what error do you get?
Best regards,
Bart
Hello
I've been testing ORACLE 10g Locator and Mapserver. There seem to be an
issue when using WFS "PropertyIsLike" filter on an ORACLE 10g Locator layer.
My WFS URL is like this:
http://test/cgi-bin/mapserv.exe?map=wfs.map&SERVICE=WFS&VERSION=1.0.0&REQUEST=getfeature&MAXFEATURES=100&TYPENAME=layer_20&FILTER=<Filter><PropertyIsLike
wildcard='*' singleChar='.' escape='!'
matchCase='false'><PropertyName>KOMMUNE</PropertyName><Literal>*123456*</Literal></PropertyIsLike></Filter>
Mapserver the produces this SQL (based on WFS filter):
SELECT ID, GEOM FROM (SELECT * FROM V_BE) WHERE KOMMUNE ilike '123456'
escape '!' AND SDO_FILTER( GEOM, MDSYS.SDO_GEOMETRY(2003, 32632,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-26932.706,6387567.41,1637291.63,8050226.99)
),'querytype=window') = 'TRUE'
In the SQL there are some errors:
"ilike '123456'" should be "like '123456'"
escape '!' should not be present at all
Could this be a bug or is there something wrong with my WFS filter URL?
Cheers!
Sture
--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl
--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst
Email: [EMAIL PROTECTED]
http://www.dmsolutions.ca/
Phone: (613) 565-5056 (ext 14)
Fax: (613) 565-0925
----------------------------------------------------------------
