I have a layer in which I need to apply multiple check box filters. For example, I need to filter a layer based on state, city and some other attribute based on user input/ CQL filter. Basically, I need a dynamic filtering based on multiple attributes on the layer using CQL. could any one suggest me an idea on how to do it?
Once you understand how to build the CQL query (web search on this should show you many examples), and since you have opengeo suite installed I would recommend using GeoExplorer as the client viewer to allow users to set their own filters or CQL filters.
- Load layer you want user to query to GeoExplorer
- Publish map and provide user with map url
The query may be defined by:
- Select layer in table of contents and right click and select Layer Properties
- Click on the Display tab and check the Limit with filters checkbox
Here you may define compound or CQL queries based on many layer field attributes. End users will be able to view the results in both tabular and spatial format (Query:table, Map:features).
I cannot tell you how to build the CQL client side, but the CQL itself can be easily built in the form of
state = 'state name' and city = 'city name' and otherAttribute = 'the value'