On Thursday, July 21, 2011 10:34:23 AM Rainer Suddendorf wrote:
> Hi,
>
> is it possible to use a subselect in a Filter?
>
> I would like to select all Features depending on values in a different
> table in an oracle database.
>
> I tried:
>
> Filter filter = CQL.toFilter(" id in (select id from xxx)");
> FeatureIterator< SimpleFeature> fi=fs.getFeatures(filter).features();
>
This sort of predicates are not possible in CQL syntax. I suggest you to
create a view previously.
>
> Thanks for your help.
>
> Rainer
--
Mauricio Pazos
------------------------------------------------------------------------------
5 Ways to Improve & Secure Unified Communications
Unified Communications promises greater efficiencies for business. UC can
improve internal communications as well as offer faster, more efficient ways
to interact with customers and streamline customer service. Learn more!
http://www.accelacomm.com/jaw/sfnl/114/51426253/
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users