I've two layers "cities" (has the fields: fid, code, and geom) and "cities_details" (has the fields: id, city_code, and area).
I need to filter "cities" layer with a condition applied on the "cities_details" layer. I believe that Geoserver's Cross-layer Filtering extension can do that.
The following CQL filter runs successfully:
code = querySingle('cities_details', 'city_code','area = 5000')
It returns the city with area = 5000.
But the following CQL filter failed:
code IN (queryCollection('cities_details', 'city_code','area >= 5000'))
I tried also the following, but didn't work:
code IN (collectGeometries(queryCollection('cities_details', 'city_code','area >= 5000')))
In both cases the log tells: org.geoserver.platform.ServiceException: Could not parse CQL filter list
Can anybody help me, how to use "IN" with the Cross-Layer Filtering