public AttendDiagInvTreatStatusVo getAttendDiagInvTreatStatus(CareContextRefVo careContextRef) { if (careContextRef == null || careContextRef.getID_CareContext() == null) return null; DomainFactory factory = getDomainFactory(); String queryNoKnownInvestigationSaved = "SELECT attendDiagInvTreatStatus from AttendDiagInvTreatStatus as attendDiagInvTreatStatus left join attendDiagInvTreatStatus.attendance as at where (at.id = :AttendenceId and (attendDiagInvTreatStatus.isRIE is null OR attendDiagInvTreatStatus.isRIE = 0) ) "; AttendDiagInvTreatStatus doAttendDiagInvTreatStatus = (AttendDiagInvTreatStatus) factory.findFirst( queryNoKnownInvestigationSaved, new String[] {"AttendenceId"}, new Object[] {careContextRef.getID_CareContext()}); return AttendDiagInvTreatStatusVoAssembler.create(doAttendDiagInvTreatStatus); }