Hibernate version 3:


Greets, I have Query like this:

select aAct.Oid from Act as aAct
where aAct.WfVariableName=?
and aAct.ClassCode=?
and aAct.InboundRelationship.Source=?
and aAct.InboundRelationship.TypeCode=?

Query produces SQL like this:

select act0_.OID as col_0_0_ from Act act0_
inner join ROOT act0_1_ on act0_.OID=act0_1_.OID,
ActRelationship inboundrel1_,
ActRelationship inboundrel2_
where act0_.OID=inboundrel2_.OID_TARGET
and act0_.OID=inboundrel1_.OID_TARGET
and act0_.EXT_WF_ST_VARIABLENAME='pkg1'
and act0_.CS_ST_CLASSCODE='OBSDEF'
and inboundrel1_.OID_SOURCE='998404'
and inboundrel2_.CS_ST_TYPECODE='COMP'


Is it possible using HQL to target InboundRelationship.Source & InboundRelationship.TypeCode to same inboundRelationship element so that produced query will be like this:

select act0_.OID as col_0_0_ from Act act0_
inner join ROOT act0_1_ on act0_.OID=act0_1_.OID,
ActRelationship inboundrel1_
where act0_.OID=inboundrel1_.OID_TARGET
and act0_.EXT_WF_ST_VARIABLENAME='pkg1'
and act0_.CS_ST_CLASSCODE='OBSDEF'
and inboundrel1_.OID_SOURCE='998404'
and inboundrel1_.CS_ST_TYPECODE='COMP'

Thanks

Try this.