Sorry, I might be misunderstanding filters. I was thinking of this: > Unless otherwise specified, none of the filter functions in this reference > are understood natively by the data stores, and thus expressions using them > will be evaluated in-memory.
So i assumed that other types of filters (except SQLViews) would simply be translations to this type of filtering. Sorry for my newbie assumptions. Also, when i try to create a SQLView, i get an error: Failed to create SQL view: ERROR: syntax error at or near ")" Position: 88 My view is simply: > select id, fid, the_geom from mytable where fid = %fid% If i remove the where clause (which makes the SQLVIew useless?), i can create it but accessing it with the &viewparams=fid:102376549 i get: > <?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE > ServiceExceptionReport SYSTEM > "http://localhost:8080/geoserver/schemas/wms/1.1.1/WMS_exception_1_1_1.dtd";> > <ServiceExceptionReport version="1.1.1" > <ServiceException > code="internalError"> > Rendering process failed > java.io.IOException > null > java.util.ArrayList cannot be cast to java.lang.String > </ServiceException></ServiceExceptionReport> --nix On Feb 14, 2013, at 08:44, Andrea Aime <[email protected]> wrote: > On Thu, Feb 14, 2013 at 2:42 PM, Robert Nix <[email protected]> wrote: > Excellent, Andrea! > SQLViews look exactly like what i need (though i haven't gotten it to work > yet … and i was kinda looking forward to some GeoServer coding ;-) > It seems to me that CQL is still doing the filtering in GeoServer? > > No, every kind of filter we have is translated back in SQL, of course, limited > by the abilities of our SQL translators > > Cheers > Andrea > > -- > == > Our support, Your Success! Visit http://opensdi.geo-solutions.it for more > information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 339 8844549 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > -------------------------------------------------------
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
