Geoserver with OGC filter not working with inclusive DATE range DATE >= x AND
DATE <= y
---------------------------------------------------------------------------------------
Key: GEOT-3526
URL: http://jira.codehaus.org/browse/GEOT-3526
Project: GeoTools
Issue Type: Bug
Affects Versions: 2.6.0
Environment: Geoserver 2.0.1, ARCSDE data store, Solaris 9, Tomcat 6,
Java 1.6.0_17
Reporter: Andrew Walsh
We are using Geoserver 2.0.1 with an ARSCDE-Oracle (ESRI) data
store. I have a simple table (point features) that has a time series of SST and
a column with a Oracle DATE type called OBS_DATE_TIME. I want
to filter the data by inclusive date range using >= and <= but its
not working. Seems only > and < operators work which isn't good
enough.
For example try this URL
(filter is: Bilgola and >=2010-12-12 08:58:00 and =< 2011-01-06 09:12:00 )
and you will 1 feature back in GML but you should get 2 features, 1 at
2010-12-12 08:58:00 and
the other at 2011-01-06 09:12:00
http://www.metoc.gov.au/geoserver/wfs?&VERSION=1.1.0&SERVICE=WFS&REQUEST=GetFeature&;
TYPENAME=test:TEST.BEACH_TEMPS&Filter=<Filter><And><PropertyIsEqualTo><PropertyName>LOCATION</PropertyName>
<Literal>Bilgola</Literal></PropertyIsEqualTo><PropertyIsGreaterThanOrEqualTo><PropertyName>OBS_DATE_TIME</PropertyName><Function
name="dateParse"><Literal>yyyy-MM-dd HH:mm:ss</Literal><Literal>2010-12-12
08:58:00</Literal></Function></PropertyIsGreaterThanOrEqualTo><PropertyIsLessThanOrEqualTo><PropertyName>OBS_DATE_TIME</PropertyName><Function
name="dateParse"><Literal>yyyy-MM-dd HH:mm:ss</Literal><Literal>2011-01-06
09:12:00</Literal></Function></PropertyIsLessThanOrEqualTo></And></Filter>
This issue may be related to issue GEOT-3525
(Random 1/1000 second precison value and time zone offset added to Oracle DATE
type on GML and CSV output from WFS)
and also GEOT-3507 (Date comparison with CQL - Bad SQL sent to Oracle)
See also following discussion threads:
http://osgeo-org.1803224.n2.nabble.com/Re-Geoserver-with-OGC-filter-not-working-with-inclusive-range-gt-AND-lt-td6282551.html
http://osgeo-org.1803224.n2.nabble.com/Date-comparisons-with-OGC-filter-and-CQL-filter-td6260247.html
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Benefiting from Server Virtualization: Beyond Initial Workload
Consolidation -- Increasing the use of server virtualization is a top
priority.Virtualization can reduce costs, simplify management, and improve
application availability and disaster protection. Learn more about boosting
the value of server virtualization. http://p.sf.net/sfu/vmware-sfdev2dev
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
