turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fabio Daprile <fabio.dapr...@wuerth-phoenix.com>
Subject How to use aliases in Crtiteria object.
Date Mon, 03 Feb 2003 15:42:01 GMT
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


Mime
View raw message