how to use WIld cards when writing wfs filters
|
View:
New views
7 Messages
—
Rating Filter:
Alert me
|
 |
how to use WIld cards when writing wfs filters
by Imran_Rajjad
::
Rate this Message:
Hi,
I need to find if Geoserver supports Wild cards in logical querying? if yes then is it the same as Oracle or do I need to follow another syntax..
in my web-app the user has to enter accurate text that should match the stored data, even the CAPS should be matched, so thats I`m trying to put in some flexibility for seach functions..any idea anyone?
regards,
Imran
-- I.R ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by Andrea Aime-4
::
Rate this Message:
Imran Rajjad ha scritto:
> Hi, > > I need to find if Geoserver supports Wild cards in logical querying? if > yes then is it the same as Oracle or do I need to follow another syntax.. > > in my web-app the user has to enter accurate text that should match the > stored data, even the CAPS should be matched, so thats I`m trying to put > in some flexibility for seach functions..any idea anyone? The protocol does not support wildcards and is case sensitive. That's just the way it has been defined. I guess that in your client you can grab the results of DescribeFeatureType and fix the attributes the user entered before sending the request to GeoServer Cheers Andrea ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by David Winslow-5
::
Rate this Message:
<ogc:PropertyIsLike wildCard="%" singleChar="_" escape="\" matchCase="false"> <ogc:PropertyName>topp:STATE_NAME</ogc:PropertyName> <ogc:Literal>AL%</ogc:Literal> </ogc:PropertyIsLike> There is an analogous operator in CQL syntax called LIKE. As far as I know, the wildCard and singleChar values are fixed to '%' and '_', and the case sensitivity can't be disabled in CQL. Hope this helps. -- David Winslow OpenGeo - http://opengeo.org/ On 10/27/2009 02:21 AM, Imran Rajjad wrote:
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by Imran_Rajjad
::
Rate this Message:
hey thanks for tip.. would be kind enough to give the CQL syntax example? because thats what Im using , but I going to give this thing a try, any idea where can I find this thing documented?
regards,
Imran
On Tue, Oct 27, 2009 at 6:23 PM, David Winslow <dwinslow@...> wrote:
-- I.R ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by Andrea Aime-4
::
Rate this Message:
David Winslow ha scritto:
> OGC filter syntax includes a PropertyIsLike filter that you can use to > do simple wildcard matching on string properties. The syntax looks like > this: > > <ogc:PropertyIsLike wildCard="%" singleChar="_" escape="\" > matchCase="false"> > <ogc:PropertyName>topp:STATE_NAME</ogc:PropertyName> > <ogc:Literal>AL%</ogc:Literal> > </ogc:PropertyIsLike> > > There is an analogous operator in CQL syntax called LIKE. As far as I > know, the wildCard and singleChar values are fixed to '%' and '_', and > the case sensitivity can't be disabled in CQL. Ha ha... in my original reply I was thinking about matching the property names, not the property values :-) David is absolutely right, we can make LIKE against the values Cheers Andrea ------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by David Winslow-5
::
Rate this Message:
CQL is part of the Catalog Service standard from OGC, described here:
http://www.opengeospatial.org/standards/cat
GeoTools and uDig also have some nice examples of CQL usage: http://docs.codehaus.org/display/GEOTDOC/01+CQL+Examples http://udig.refractions.net/confluence/display/EN/Common+Query+Language You can also experiment with both CQL and OGC filter syntax in GeoServer's OpenLayers demo page. Hope this helps. -- David Winslow OpenGeo - http://opengeo.org/ On 10/27/2009 11:33 PM, Imran Rajjad wrote:
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
|
|
Re: how to use WIld cards when writing wfs filters
by Mauricio Pazos
::
Rate this Message:
On Wednesday 28 October 2009 04:33:27 am Imran Rajjad wrote:
> hey thanks for tip.. would be kind enough to give the CQL syntax example? http://docs.codehaus.org/display/GEOTDOC/01+CQL+Examples > because thats what Im using , but I going to give this thing a try, any > idea where can I find this thing documented? You can find the BNF in http://docs.codehaus.org/display/GEOTOOLS/CQL+Parser+Design > > regards > cheers -- Mauricio Pazos www.axios.es ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Geoserver-users mailing list Geoserver-users@... https://lists.sourceforge.net/lists/listinfo/geoserver-users |
| Free embeddable forum powered by Nabble | Forum Help |
