public ims.core.vo.ServiceShortVoCollection listServices(String serviceName) { StringBuilder hqlBuilder = new StringBuilder( "select s1_1 from ReferralService as r1_1 left join r1_1.referralServices as s1_1 where s1_1.upperName like :servName and s1_1.isActive = 1 "); List<?> dos = getDomainFactory().find(hqlBuilder.toString(), "servName", serviceName.toUpperCase() + "%"); if (dos == null || dos.size() == 0) return null; return ServiceShortVoAssembler.createServiceShortVoCollectionFromService(dos); }