public SocialHistoryLiteVoCollection getSocialHistoryByPatientColl( PatientRefVo patient) { if(patient == null || patient.getID_Patient() == null) return null; DomainFactory factory = getDomainFactory(); String hql = "from SocialHistory socHist where socHist.careContext.episodeOfCare.careSpell.patient.id = :idPatient order by socHist.authoringInformation.authoringDateTime desc"; List socialHistory = factory.find(hql, new String[] {"idPatient"}, new Object[] {patient.getID_Patient()}); if (socialHistory != null && socialHistory.size() > 0) return SocialHistoryLiteVoAssembler.createSocialHistoryLiteVoCollectionFromSocialHistory(socialHistory); return null; }