When I try a LIKE Filter eg
<ogc:Filterxmlns:ogc="http://www.opengis.net/ogc">
<ogc:And>
<ogc:PropertyIsLikewildCard="*"singleChar="."escapeChar="!">
<ogc:PropertyName>WELL_NAME</ogc:PropertyName>
<ogc:Literal>wainui*</ogc:Literal>
</ogc:PropertyIsLike>
</ogc:And>
</ogc:Filter>
I note that it is case-sensitive when I run on geoserver 2.0.2 against
ArcSDE 9.3. I want to do a case-insensitive LIKE. Earlier discussions
seemed to imply this was coming. What is the state of play? Is there a
way to do case-insensitive LIKE filters? Is it coming in the future?
--
Phil Scadden, Senior Scientist GNS Science Ltd 764 Cumberland St,
Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477 5232
Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents.
Hi Phil,
is there no <ogc:Function name="upper"> type of thing you can use ?
-ivan
Le 7/04/2011 12:10 AM, Phil Scadden a écrit :
When I try a LIKE Filter eg
<ogc:Filterxmlns:ogc="http://www.opengis.net/ogc">
<ogc:And>
<ogc:PropertyIsLikewildCard="*"singleChar="."escapeChar="!">
<ogc:PropertyName>WELL_NAME</ogc:PropertyName>
<ogc:Literal>wainui*</ogc:Literal>
</ogc:PropertyIsLike>
</ogc:And>
</ogc:Filter>
I note that it is case-sensitive when I run on geoserver 2.0.2 against
ArcSDE 9.3. I want to do a case-insensitive LIKE. Earlier discussions
seemed to imply this was coming. What is the state of play? Is there a
way to do case-insensitive LIKE filters? Is it coming in the future?
Hey Phil,
try adding matchCase="false" as an attribute to the ogc:PropertyIsLike tag.
As I understand it, it is implemented in GeoServer, but not for all
datastores (Oracle for sure, other ones I don't know).
Best regards,
Bart
When I try a LIKE Filter eg
<ogc:Filterxmlns:ogc="http://www.opengis.net/ogc">
<ogc:And>
<ogc:PropertyIsLikewildCard="*"singleChar="."escapeChar="!">
<ogc:PropertyName>WELL_NAME</ogc:PropertyName>
<ogc:Literal>wainui*</ogc:Literal>
</ogc:PropertyIsLike>
</ogc:And>
</ogc:Filter>
I note that it is case-sensitive when I run on geoserver 2.0.2 against
ArcSDE 9.3. I want to do a case-insensitive LIKE. Earlier discussions
seemed to imply this was coming. What is the state of play? Is there a
way to do case-insensitive LIKE filters? Is it coming in the future?
--
Phil Scadden, Senior Scientist GNS Science Ltd 764 Cumberland St,
Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477
5232
Notice: This email and any attachments are confidential. If received in
error please destroy and immediately notify us. Do not copy or disclose
the contents.
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
try adding matchCase="false" as an attribute to the ogc:PropertyIsLike tag.
As I understand it, it is implemented in GeoServer, but not for all
datastores (Oracle for sure, other ones I don't know).
Okay, I'll try it. If it works it should be added to OpenLayers. I note
the matchCase is honoured in Openlayers (though not documented) for
filters other than like but doesnt do it for like.
Ivan - strUpper is possible but setting up functions for generic code
using Openlayers is causing some head scratching for me. The matchCase
mechanism moves the responsibility from client to the wfs server
implementation which is where I think it should be.
--
Phil Scadden, Senior Scientist GNS Science Ltd 764 Cumberland St,
Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477 5232
Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents.
It was updated for LIKE a few days ago in OpenLayers trunk.
http://trac.osgeo.org/openlayers/ticket/3247
Best regards,
Bart
--
Looking for flexible support on OpenLayers or GeoExt? Please check out http://www.osgis.nl/support.html
Bart van den Eijnden
OSGIS
bartvde@anonymised.com
On Apr 7, 2011, at 11:20 PM, Phil Scadden wrote:
try adding matchCase="false" as an attribute to the ogc:PropertyIsLike tag.
As I understand it, it is implemented in GeoServer, but not for all
datastores (Oracle for sure, other ones I don't know).
Okay, I'll try it. If it works it should be added to OpenLayers. I note
the matchCase is honoured in Openlayers (though not documented) for
filters other than like but doesnt do it for like.
Ivan - strUpper is possible but setting up functions for generic code
using Openlayers is causing some head scratching for me. The matchCase
mechanism moves the responsibility from client to the wfs server
implementation which is where I think it should be.
--
Phil Scadden, Senior Scientist GNS Science Ltd 764 Cumberland St,
Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477 5232
Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents.
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
On Thu, Apr 7, 2011 at 11:20 PM, Phil Scadden <p.scadden@anonymised.com> wrote:
try adding matchCase="false" as an attribute to the ogc:PropertyIsLike tag.
As I understand it, it is implemented in GeoServer, but not for all
datastores (Oracle for sure, other ones I don't know).
Okay, I'll try it. If it works it should be added to OpenLayers. I note
the matchCase is honoured in Openlayers (though not documented) for
filters other than like but doesnt do it for like.
Not surprising, matchCase is not part of the Filter specification for
PropertyIsLike,
it's something we started slowly to add based on user feedback.
Afaik WFS 2.0/Filter 2.0 should add official support for matchCase also in like
comparisons.
Ivan - strUpper is possible but setting up functions for generic code
using Openlayers is causing some head scratching for me. The matchCase
mechanism moves the responsibility from client to the wfs server
implementation which is where I think it should be.
A colleague of mine provided just some time ago a way to encode
functions in OpenLayers, the latest release should have that new
support code (before it was just not possible to encode a filter function).
I know it works for filter functions embedded in spatial filters, not 100%
sure it will work in your case
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
mob: +39 333 8128928
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
Thanks all. That is very encouraging.
Notice: This email and any attachments are confidential. If received in error please destroy and immediately notify us. Do not copy or disclose the contents.