cmd.join (DEP.C_DEPARTMENT_ID, EMP.C_DEPARTMENT_ID);
// Set filter constraints
SearchInfo si = getSearchInfo();
if (si.getDepartmentId()!=null)
cmd.where(EMP.C_DEPARTMENT_ID.is(si.getDepartmentId()));
if (StringUtils.isValid( si.getFirstName()) )
cmd.where(EMP.C_FIRSTNAME.likeUpper( si.getFirstName()+"%" )
.or(EMP.C_FIRSTNAME.is(null)));
if (StringUtils.isValid( si.getLastName()) )
cmd.where(EMP.C_LASTNAME.likeUpper( si.getLastName()+"%" ));