Author: fdesbois Date: 2009-08-31 19:12:10 +0200 (Mon, 31 Aug 2009) New Revision: 67 Modified: trunk/bonzoms-business/src/main/java/org/chorem/bonzoms/impl/ServicePersonXPIL.java Log: Add alias for Relationship in Hql Query Modified: trunk/bonzoms-business/src/main/java/org/chorem/bonzoms/impl/ServicePersonXPIL.java =================================================================== --- trunk/bonzoms-business/src/main/java/org/chorem/bonzoms/impl/ServicePersonXPIL.java 2009-08-31 16:37:36 UTC (rev 66) +++ trunk/bonzoms-business/src/main/java/org/chorem/bonzoms/impl/ServicePersonXPIL.java 2009-08-31 17:12:10 UTC (rev 67) @@ -62,10 +62,10 @@ PartyRoleEntityDAO roleDAO = BonzomsModelDAOHelper.getPartyRoleEntityDAO(transaction); List<RelationshipEntity> employments = transaction.find( - "FROM " + RelationshipEntity.class.getName() + - " WHERE " + RelationshipEntity.FROM_ROLE + "." + PartyRoleEntity.PARTY_ENTITY + " = :person " + - " AND " + RelationshipEntity.RELATIONSHIP_TYPE + "." + RelationshipType.NAME + " = :type" + - " ORDER BY " + RelationshipEntity.FROM_DATE + " DESC, " + RelationshipEntity.THRU_DATE + " DESC", + "FROM " + RelationshipEntity.class.getName() + " as rel " + + " WHERE rel." + RelationshipEntity.FROM_ROLE + "." + PartyRoleEntity.PARTY_ENTITY + " = :person " + + " AND rel." + RelationshipEntity.RELATIONSHIP_TYPE + "." + RelationshipType.NAME + " = :type" + + " ORDER BY rel." + RelationshipEntity.FROM_DATE + " DESC, rel." + RelationshipEntity.THRU_DATE + " DESC", "person", entity, "type", RelationshipTypeValues.EMPLOYMENT);