I have a cascaded (WFS store) layer in my GeoServer. I want to download the data of the layer in Excel format for a provided polygon. In a normal scenario I export the data as below:
https://my-geoserver/workspace/wfs?service=WFS&request=GetFeature&version=1.1.0&typeName=layerName&outputFormat=excel2007&CQL_FILTER=intersects(GEOM,POLYGON((140622.7275518125 158136.306018296,140676.74283158602 158165.31859678068,140714.0110057701 158091.48983712035,140661.41098439335 158063.18487973593,140622.7275518125 158136.306018296)))
But in case of the cascaded layer the above is not working, an empty Excel spreadsheet is being downloaded. I tried OGC filter as well, but same result.
I know I can achieve this by using BBOX but I cannot use BBOX for intersecting as the intersecting needs to be a polygon for filtering purpose of the layer I'm trying to export.
Cascaded layer: I have created a WFS store in my GeoServer and exposing the layer.