public ChemotherapyDetailsShortVoCollection listChemotherapies(EpisodeOfCareRefVo episodeOfCare, CareContextRefVo careContext) { if (episodeOfCare == null || !episodeOfCare.getID_EpisodeOfCareIsNotNull()) throw new DomainRuntimeException("Null or invalid episode of care passed"); StringBuilder query = new StringBuilder(); query.append(" from ChemotherapyDetails as ctd where ctd.episodeOfCare.id = :EP_ID order by ctd.startDate desc"); ArrayList<String> paramNames = new ArrayList<String>(); ArrayList<Object> paramValues = new ArrayList<Object>(); paramNames.add("EP_ID"); paramValues.add(episodeOfCare.getID_EpisodeOfCare()); // if (careContext == null || !careContext.getID_CareContextIsNotNull()) // { // query.append(" and ctd.careContext.id = :CC_ID"); // // paramNames.add("CC_ID"); // paramValues.add(careContext.getID_CareContext()); // } return ChemotherapyDetailsShortVoAssembler.createChemotherapyDetailsShortVoCollectionFromChemotherapyDetails(getDomainFactory().find(query.toString(), paramNames, paramValues)); }