turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Quinton McCombs" <qmcco...@nequalsone.com>
Subject RE: How to use aliases in Crtiteria object.
Date Mon, 03 Feb 2003 16:10:37 GMT
Look at the javadocs for the Criteria object.  The method that you want to use is Criteria.addAlias().

> -----Original Message-----
> From: Fabio Daprile [mailto:fabio.daprile@wuerth-phoenix.com] 
> Sent: Monday, February 03, 2003 9:42 AM
> To: Turbine Users List
> Subject: How to use aliases in Crtiteria object.
> 
> 
> Hello everybody,
> 
> i would like to ask you how it is possible to implement the following 
> query using the Criteria object:
> 
> select a.ticketId
> from    
>     TicketVersions as d, TicketVersions as a, Versions as b, 
> Versions as c where
>     ((a.versiontype = 'Fixed' and b.description = 'not set') and 
> (a.versionid = b.id))
> and
>     ((d.versiontype = 'Raised' and c.description = 'PB_INC5')and 
> (d.versionid = c.id))
> and
>     (a.ticketid = d.ticketid)
> 
> ii'll be grateful for any help.
> 
> thx in advance
> 
> Fabio Daprile
> 
> -- 
> Fabio Daprile
> 
> W├╝rth Phoenix srl - GmbH
> Via Kravoglstrasse 4
> 39100 Bolzano / Bozen
> Tel.  +39 0471 564 111 - (direct 564068)
> Fax  + 39 0471 564 122
> fabio.daprile@wuerth-phoenix.com
> 
http://www.wuerth-phoenix.com
http://www.wuerth.com



---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message