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);
  }