public OrderCategory getOrderCategoryByMap() { DomainFactory factory = getDomainFactory(); StringBuffer hql = new StringBuffer(); hql.append("select lookInst from Lookup as look left join look.instances as lookInst left join lookInst.mappings as mappings where (look.id = 1161035 and mappings.extSystem = 'MAXIMS' and mappings.extCode like 'ALIAS_DEFAULT' and lookInst.active = 1)"); List<?> list = factory.find(hql.toString()); if (list!=null && list.size()>0) { LookupInstance doLookInst=(LookupInstance)list.get(0); ims.ocrr.vo.lookups.OrderCategory voLookup = new ims.ocrr.vo.lookups.OrderCategory(doLookInst.getId(),doLookInst.getText(),doLookInst.isActive(),null,doLookInst.getImage(),doLookInst.getColor()); return voLookup; } return null; }