// filters.add(cb.equal(r.get("intId"), intId));
filters.add(cb.equal(r.get("serviceRequestPK").get("intFlId"), intFlId));
filters.add(cb.equal(r.get("serviceRequestPK").get("intRefNumber"), intRefNumber));
// filters.add(cb.not(cb.in(r.get("_recStatus")).value("X")));
filters.add(cb.notEqual(r.get("_recStatus"),"X"));
cq.where(cb.and(filters.toArray(new Predicate[0])));
List<EntDbServiceRequest> resultList = getEntityManager().createQuery(cq).getResultList();
if (resultList != null && resultList.size() > 0){
result = resultList.get(0);