Re: Unable to create Criteria object or executeQuery

Richard Bayet wrote:

> Thomas Fischer wrote:
>
> > Hi,
> >
> > I do remember there was a discussion about this in the user mailing list
> > some time ago. The problem with your statement is that it uses 
> > subselects,
> > which is not (yet ???) supported in torque (contributions are 
> > welcome). One
> > solution was to manually create a view in the database [...]
> >
> >      Thomas
>
> Well, the kind of subselect he wants to perform is not yet supported, 
> but "classical" subselects are supported, aren't they ?
> (Like "select A, B from T1, T2
> where A in (select MAX(C) from T3 ...)
> and ...").
>
> But I might be wrong, I know I had to extend the Criteria class to code 
> a "not in" operator. I got the idea from either the dev or user 
> mailing-list.

Here it is.
http://nagoya.apache.org/eyebrowse/ReadMsg?listName=torque-user@xxxxxxxxxxxxx&msgId=1739554
(If direct link fails, head to 
http://nagoya.apache.org/eyebrowse/ReadMsg?listName=torque-user@xxxxxxxxxxxxx&msgId=1739554
and search messages bodies for "SimpleCriteria").
You were right, subqueries aren't supported but they can be easily added.


Regards.