Re: [Geotools-gt2-users] SQL as Filter

[Mauricio P. <mau...@gm...>]

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