Hi Arnd, good catch, it does not. Geoserver does.
Best regards, Bart Arnd Wippermann wrote: > Hi, > > Does MapServer support CQL? If so I would be interested. Can someone point > me to a source, how to use it? Internet search shows nothing for MapServer. > > Arnd Wippermann > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im > Auftrag von Brenningmeyer, Todd > Gesendet: Donnerstag, 14. August 2008 17:19 > An: [EMAIL PROTECTED] > Cc: Openlayers Users List > Betreff: Re: [OpenLayers-Users] CQL queries with WFS > > I used the code below but the map still returned all of the villages. It > seems very strange that both my CQL_Filter and URL style filters aren't > working. I'm sure I'm missing something but the filter process just doesn't > seem to like my queries (at least in terms of the syntax I'm using). The > CQL_Filter params did appear in the params section within firebug when I ran > it but in a vertical format with each letter listed after a number...so 0 C > 1 Q 2 L and so on in a vertical column. I'm not sure if this makes sense or > if it is important to the filter problem. Thanks again for your help. If > you have any other suggestions about using the CQL_FILTER or a URL style > filter please let me know. I've been tinkering with this for quite a while > without success so your help is very much appreciated. > Thanks again, > Todd > > var wfsLayer = new OpenLayers.Layer.WFS( "villages", > > "http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.map&typen > ame=villages&request=getfeature&version=1.0.0&service=wfs&", > { > styleMap: oStyleMap > } > ); > var value = "nomos='Eleia'"; > wfsLayer.mergeNewParams('CQL_FILTER:' + escape(value)); (I've used both : > and = after CQL_FILTER but neither seemed to work) > > ________________________________ > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thu 8/14/2008 9:23 AM > To: Brenningmeyer, Todd > Cc: [EMAIL PROTECTED]; Andreas Hocevar; Eric Lemoine; Openlayers Users List > Subject: RE: [OpenLayers-Users] CQL queries with WFS > > > > Can you try something like: > > var wfsLayer = new OpenLayers.Layer.WFS( "villages", > > http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.map&typena > me=villages&request=getfeature&version=1.0.0&service=wfs&,{ > { > styleMap: oStyleMap > } > ); > var value = "nomos='Eleia'"; > wfsLayer.mergeNewParams({'CQL_FILTER', escape(value)}); > > Best regards, > Bart > > >> Bart, >> I tried escaping the quotes around the value of the nomos but >> unfortunately it didn't change the returned results. I used >> backslashes in front of the single quotes around Eleia. Is this what you >> > had in mind? > >> It may be that I'm not escaping the right part of the filter. >> Thanks, >> Todd >> wfsLayer = new OpenLayers.Layer.WFS( "villages", >> >> > http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.map&CQL_FI > LTER=nomos=\'Eleia\'&typename=villages&request=getfeature&version=1.0.0&serv > ice=wfs,{ > >> { >> styleMap: oStyleMap >> } >> ); >> >> ________________________________ >> >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >> Sent: Thu 8/14/2008 8:52 AM >> To: Brenningmeyer, Todd >> Cc: Andreas Hocevar; Eric Lemoine; Openlayers Users List >> Subject: Re: [OpenLayers-Users] CQL queries with WFS >> >> >> >> Have you tried escaping the value of your parameter CQL_FILTER? >> >> Best regards, >> Bart >> >> >>> Thanks Andreas and Eric. I've tried a few different options with the >>> filter but without success. I'm using the following filter and have >>> tried this with the map location moved into the params section and a >>> few other times with everything in a single URL request but still no >>> luck. The request returns all of the villages with none of these >>> filtered out. If you have any ideas that might help please let me >>> know. Thanks again for your help. >>> Todd >>> wfsLayer = new OpenLayers.Layer.WFS( "villages", >>> >>> > "http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.map&CQL_F > ILTER=nomos='Eleia' > >>> <http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.ma >>> p&CQL_FILTER=nomos='Eleia',{// >>> <http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.ma >>> p&CQL_FILTER=nomos='Eleia',{// >>> <http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.ma >>> p&CQL_FILTER=nomos='Eleia',{//<Filter> > >>> >>>> <PropertyIsEqualTo><PropertyName>nom_nr</PropertyName><Literal>39</L >>>> iteral></PropertyIsEqualTo></Filter> >>>> >>> ",{ >>> service: "WFS", >>> typename: "villages", >>> request: "getfeature", >>> version: "1.0.0" >>> }, >>> { >>> extractAttributes: true >>> } >>> ); >>> >>> Attempt with the params moved into the URL: >>> wfsLayer = new OpenLayers.Layer.WFS( "villages", >>> >>> > "http://localhost/cgi-bin/mapserv.exe?map=../htdocs/amap/sites_wfs.map&CQL_F > ILTER=nomos='Eleia'&typename=villages&request=getfeature&version=1.0.0&servi > ce=wfs",{ > >>> styleMap: oStyleMap >>> } >>> ); >>> >>> ________________________________ >>> >>> From: Andreas Hocevar [mailto:[EMAIL PROTECTED] >>> Sent: Wed 8/13/2008 7:11 AM >>> To: Eric Lemoine >>> Cc: Brenningmeyer, Todd; Openlayers Users List >>> Subject: Re: [OpenLayers-Users] CQL queries with WFS >>> >>> >>> >>> Hi, >>> >>> On Wed, Aug 13, 2008 at 2:08 PM, Eric Lemoine <[EMAIL PROTECTED]> >>> wrote: >>> >>>> On Wed, Aug 13, 2008 at 11:49 AM, Andreas Hocevar >>>> <[EMAIL PROTECTED]> wrote: >>>> >>>>> Hi, >>>>> >>>>> Since CQL_FILTER is not part to the WMS spec, the best way is to >>>>> add the filter to the WMS url, e.g. >>>>> >>>>> var layer=new OpenLayers.Layer.WMS("cql", >>>>> "http://your-server/wms?CQL_FILTER=foo<3", params, options); >>>>> >>>> Todd's question related to WFS, but I guess the response is similar, >>>> isn't it? >>>> >>> Should be, yes. Just s/WMS/WFS/gi. >>> >>> Regards, >>> Andreas. >>> >>> No virus found in this incoming message. >>> Checked by AVG - http://www.avg.com <http://www.avg.com/> >>> <http://www.avg.com/> <http://www.avg.com/> >>> Version: 8.0.138 / Virus Database: 270.6.2/1609 - Release Date: >>> 8/13/2008 >>> 6:43 AM >>> >>> >>> _______________________________________________ >>> Users mailing list >>> Users@openlayers.org >>> http://openlayers.org/mailman/listinfo/users >>> >>> >> >> >> >> > > > > > _______________________________________________ > Users mailing list > Users@openlayers.org > http://openlayers.org/mailman/listinfo/users > > _______________________________________________ > Users mailing list > Users@openlayers.org > http://openlayers.org/mailman/listinfo/users > > > -- Bart van den Eijnden OSGIS, Open Source GIS [EMAIL PROTECTED] http://www.osgis.nl _______________________________________________ Users mailing list Users@openlayers.org http://openlayers.org/mailman/listinfo/users