I'm trying to query the database (DataStore) and want to let the datastore calculate a value for me.
In SQL I would do it like this:
SELECT name, ST_Area(ST_Intersection(the_geom, ....) AS myValue FROM ...
Is there any way, how I can do this with CQL. My current approach is this, but I do not know how to add this calculated field. I need this, as I want to sortBy this field.
DataStore ds = ... Filter filter = CQL.toFilter("INCLUDE"); SimpleFeatureCollection features = source.getFeatures(filter);
Any idea, how to add my area function to the resultset?