<statement id="dynamicGetAccountList"
resultMap="account-result" >
select * from ACCOUNT
<dynamic prepend="WHERE">
<isNotNull prepend="AND" property="firstName">
(ACC_FIRST_NAME = #firstName#
<isNotNull prepend="OR" property="lastName">
ACC_LAST_NAME = #lastName#
</isNotNull>
)
</isNotNull>
<isNotNull prepend="AND" property="emailAddress">
ACC_EMAIL like #emailAddress#
</isNotNull>
<isGreaterThan prepend="AND" property="id" compareValue="0">
ACC_ID = #id#
</isGreaterThan>
</dynamic>
order by ACC_LAST_NAME
</statement>

public List queryByCriteriaMap(Map map) throws ServiceException, HibernateException {
   
    List list = null;
    Criteria modelCriteria = null;
    Criteria crit = this.getSession().createCriteria(Netelement.class);
   
    if (map.containsKey("elementName")) {
        crit.add(Expression.eq("name", map.get("elementName")));
    }
   
    if (map.containsKey("vendorName")) {
        if (modelCriteria ==null) {
            modelCriteria = crit.createCriteria("model");
        }
       
        modelCriteria.createCriteria("vendor").add(Expression.eq("name", map.get("vendorName")));
    }
   
    if (map.containsKey("modelDesc")) {
        if (modelCriteria ==null) {
            modelCriteria = crit.createCriteria("model");
        }
        //crit.add(Expression.eq("model.description", map.get("modelDesc")));
        modelCriteria.add(Expression.eq("description", map.get("modelDesc")));
    }
   
    if (map.containsKey("type")) {
        if (modelCriteria ==null) {
            modelCriteria = crit.createCriteria("model");
        }
       
        modelCriteria.createCriteria("deviceType").add(Expression.eq("name", map.get("type")));
    }
   
   
    if (map.containsKey("ipaddr")) {
        crit.add(Expression.eq("ipaddr", map.get("ipaddr")));
    }
   
    if (map.containsKey("globalsync")) {
       
   
        crit.add(Expression.eq("globalsync", map.get("globalsync")));
    }
   
    if (map.containsKey("agentName")) {
        Criteria agentCriteria = crit.createCriteria("Agents");
        agentCriteria.add(Expression.eq("name", map.get("agentName")));
    } 
   
    if (map.containsKey("containerName")) {
        Criteria containerCriteria = crit.createCriteria("containers");
        containerCriteria.add(Expression.eq("name", map.get("containerName")));
    }
    return crit.list();
   
}