TransWikia.com

Geoserver CQL filter with many “IN” conditions

Geographic Information Systems Asked on August 30, 2021

I am using Geoserver to generate colored regions on a map a wms link, CQL condition can contain a long string of "IN". Max number of INs could be up to 1-2 thousands. I tried to divide it into 3 requests, but such filters are loading the processors very much. Is there any way to get the result and not use long CQL filters?
CQL filter example

One Answer

The list of IDs still need to be communicated, and the WMS protocol is entirely stateless, so it needs to be communicated at every request. What you can do, is to switch to POST requests instead of GET, putting all the query parameters into a application/x-www-form-urlencoded payload (same as if you were posting a HTML form).

Answered by Andrea Aime on August 30, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP