public WheelchairSkillsShortVoCollection listWheelchairSkillsByCareContext(CareContextRefVo voCareContextRef) { DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(" "); String query = "from WheelchairSkills w "; ArrayList markers = new ArrayList(); ArrayList values = new ArrayList(); String andStr = " "; if (voCareContextRef != null) { hql.append(andStr + " w.clinicalContact.careContext.id = :id_cc"); markers.add("id_cc"); values.add(voCareContextRef.getID_CareContext()); andStr = " and "; } if (markers.size() > 0) query += " where "; query += hql.toString(); List skills = factory.find(query, markers, values); WheelchairSkillsShortVoCollection voWheelchairSkillsShortColl = WheelchairSkillsShortVoAssembler.createWheelchairSkillsShortVoCollectionFromWheelchairSkills(skills); if(voWheelchairSkillsShortColl != null && voWheelchairSkillsShortColl.size()>0) return voWheelchairSkillsShortColl; return null; }