If you really need to use SQL you can look at support for SQL queries (and parametrized SQL queries) in the user guide.
You may be able to accomplish something similar using the WPS transform process: 1) use the input as the layer you wish to process 2) use the process transform to rename an attribute. See the geotools docs here <https://docs.geotools.org/stable/userguide/unsupported/process/process-feature.html> for an example of "Rename or remove attributes". -- Jody Garnett On Wed, 11 Sep 2019 at 00:13, mark <mc.pr...@gmail.com> wrote: > On 9/10/19 1:16 AM, 1520 gis wrote: > > Dear developers, > > I am running a query through a WFS request using CQL, and I wonder If can > have an alias to the attribute ts_coleta (BeginDate) and ts_coleta(EndDate) > *FROM* > cql_filter=ts_coleta>'2019-07-01T03:00:00Z' AND > ts_coleta<'2019-07-10T03:00:00Z'& > > *TO* > cql_filter=ts_coleta as BeginDate>'2019-07-01T03:00:00Z' AND ts_coleta as > EndDate<'2019-07-10T03:00:00Z'& > > > I don't think so; the response would be of a different featuretype than > what you requested > > -M > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
