}
hqlBuilder.append(" order by created_on desc");
List result = baseService.findVOByHQL(hqlBuilder.toString());
Iterator it = result.iterator();
list = new ArrayList<ContactVO>();
ContactVO contactVO = null;
String firstName = null;
String lastName = null;
String title = null;
String email = null;
String primaryStreet = null;
String primaryCity = null;
String primaryState = null;
String primaryPostalCode = null;
while (it.hasNext()) {
Object[] row = (Object[]) it.next();
contactVO = new ContactVO();
firstName = (String) row[0];
lastName = (String) row[1];
title = (String) row[2];
email = (String) row[3];
primaryStreet = (String) row[4];
primaryCity = (String) row[5];
primaryState = (String) row[6];
primaryPostalCode = (String) row[7];
contactVO.setFirst_name(CommonUtil.fromNullToEmpty(firstName));
contactVO.setLast_name(CommonUtil.fromNullToEmpty(lastName));
contactVO.setTitle(CommonUtil.fromNullToEmpty(title));
contactVO.setEmail(CommonUtil.fromNullToEmpty(email));
contactVO.setPrimary_street(CommonUtil
.fromNullToEmpty(primaryStreet));
contactVO.setPrimary_city(CommonUtil.fromNullToEmpty(primaryCity));
contactVO
.setPrimary_state(CommonUtil.fromNullToEmpty(primaryState));
contactVO.setPrimary_postal_code(CommonUtil
.fromNullToEmpty(primaryPostalCode));
list.add(contactVO);
}
map = new HashMap<String, Object>();
}