Dear Pedro, I would check this page: http://docs.codehaus.org/display/GEOTDOC/01+CQL+Examples Regards, Simone Giannecchini ------------------------------------------------------- Ing. Simone Giannecchini GeoSolutions S.A.S. Founder
Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 mob: +39 333 8128928 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/simonegiannecchini http://twitter.com/simogeo ------------------------------------------------------- On Fri, Mar 25, 2011 at 12:26 PM, Pedro Briones Garcia <p...@tragsa.es> wrote: > Hii all > > > > I am working > > with Geoserver 2.0. I have created an Oracle View (not a parametric view in > Geoserver, just the tradicional Oracle view) to visualize with Geoserver. > This view has a DATE field (FH_FCHMUESTREO). I want to make a filter on the > field FH_FCHMUESTREO using a CQL Filter, but I can not: > > What I am using is: > > …&CQL_FILTER+=+FH_FCHMUESTREO=5/10/10 > > > > I've tried with and without single and double quotes. > > In Oracle, this DATE field has values like 05.03.10 . When I make an > identify in Geoserver, I get a value of type 5/03/10 0:00. > > How do I enter the date value to be understood by Geoserver? > > Thanks in advance. > > > > Un saludo. > > > > Pedro Briones García > > > > TRAGSATEC > > Gerencia de SIG y Consultoría > > Departamento de Cartografía > > C/ Julián Camarillo 6, Edificio 6B - 2ª Pl. Sector B > > 28037 Madrid > > mailto:p...@tragsa.es > > Tfno.: +34 91 322 6489 > > > > > > ------------------------------------------------------------------------------ > Enable your software for Intel(R) Active Management Technology to meet the > growing manageability and security demands of your customers. Businesses > are taking advantage of Intel(R) vPro (TM) technology - will your software > be a part of the solution? Download the Intel(R) Manageability Checker > today! http://p.sf.net/sfu/intel-dev2devmar > _______________________________________________ > Geoserver-users mailing list > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ Geoserver-users mailing list Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
