public PlinthWorkShortVoCollection getPlinthWorkByCareContext(CareContextRefVo voCareContextRef) { DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(); String query = "from PlinthWork pw "; ArrayList markers= new ArrayList(); ArrayList values = new ArrayList(); String andStr = " "; if(voCareContextRef != null) { hql.append(andStr + " pw.clinicalContact.careContext.id = :cc"); markers.add("cc"); values.add(voCareContextRef.getID_CareContext()); andStr = " and "; } if (markers.size() > 0) query += " where "; query += hql.toString(); java.util.List pwList = factory.find(query,markers,values); PlinthWorkShortVoCollection voPlinthWorkShortColl = PlinthWorkShortVoAssembler.createPlinthWorkShortVoCollectionFromPlinthWork(pwList); //if(voPlinthWorkShortColl.size()>0) return voPlinthWorkShortColl; //wdev-13560 //else // return null; }