How can I use CQL in WFS layers in openlayers

Question

I've tried a lot of times to use the OpenLayers CQL example but nothing changes. Is there any way to use CQL or filter.

Answer 1

You have CQL in example:

STATE_ABBR >= 'B' AND STATE_ABBR <= 'O'

Try to change B to A and you will see change

STATE_ABBR >= 'A' AND STATE_ABBR <= 'O'

BTW OpenLayers supports less function then GeoServer but you can read http://docs.geoserver.org/stable/en/user/tutorials/cql/cql_tutorial.html

Answer 2

try to use this code:

lyr = new OpenLayers.Layer.WMS(yourLayerName, yourLayerService,{
      'VERSION' : '1.1.0',
      'layers' : yourLayerNum,
      format: 'image/png',
      transparent: true,
      CQL_FILTER: "STATE_ABBR >= 'B' AND STATE_ABBR <= 'O'"

},
      isBaseLayer: false
);

map.addLayer(lyr);

dont forget VERSION is important for getting true result.

i hope it helps you...