Re: Hibernate zacatecnicky dotaz

Tue, 13 May 2008 23:14:38 -0700

ak sa este dobe pamatam, pre "nested" podmienky (a aj ordery) bolo treba robit aliasy: 

http://www.hibernate.org/hib_docs/reference/en/html/querycriteria.html

napr nieco podobne::

List results = session.createCriteria(Domestic.class, "cat")
   *.createAlias("kittens", "kit")*
   .setProjection( Projections.projectionList()
       .add( Projections.property("cat.name"), "catName" )
       .add( Projections.property("kit.name"), "kitName" )
   )
   .addOrder( Order.asc("catName") )
   .addOrder( Order.asc("kitName") )
   .list();


ale mozno sa to uz zmenilo :)
CoPLaS

Lubos Vrba  wrote / napísal(a):

Ahoj *,
mam zapeklity dotaz.
Mam dve tabulky:
DOCUMENT sloupce ID a OPERATOR_ID
OPERATOR ma sloupce USERNAME a ID.
Pomoci criterii bych chtel radit DOCUMENTy podle username OPERATORu. (select d.id <http://d.id> from document d, operator o where d.operator_id = o.id <http://o.id> order by o.username) 
Trida Document ma property jen 'id' a 'operatorId'.
Mohl by me nekdo pomoci nebo aspon odkazat na nejakou stranku?
Diky, 
L.

Odpovedet emailem