Examples of javax.persistence.criteria.CriteriaBuilder.notEqual()

Class javax.persistence.criteria.CriteriaBuilder

Examples of javax.persistence.criteria.CriteriaBuilder.notEqual()

javax.persistence.criteria.CriteriaBuilder.notEqual()
Create a predicate for testing the arguments for inequality. @param x expression @param y expression @return inequality predicate

   //  cq.select(r.get("intId"));
     cq.select(r);
       List<Predicate> filters = new LinkedList<>();
       filters.add(cb.equal(r.get("idLoadPax"), idLoadPax));
//       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])));
     result = getEntityManager().createQuery(cq).getResultList();
     
     
     return result;

View Full Code Here

//        cq.where(predicate);
        
          List<Predicate> filters = new LinkedList<>();
          filters.add(cb.equal(r.get("taskId"), taskId));
//          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<EntDbFltJobTask> resultList = em.createQuery(cq).getResultList();
        
        if (resultList != null && resultList.size() > 0){
          result = resultList.get(0);

View Full Code Here

    cq.select(r);
//    Predicate predicate = cb.equal(r.get("idFltJobTask"), idFltJobTask);
//    cq.where(predicate);
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));
      filters.add(cb.notEqual(r.get("recStatus"),"X"));
//      filters.add(cb.not(cb.in(r.get("recStatus")).value('X')));
    cq.where(cb.and(filters.toArray(new Predicate[0])));
//      List<Predicate> filters = new LinkedList<>();
//      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));

View Full Code Here

//    Predicate predicate = cb.equal(r.get("shiftId"), shiftId);
//    cq.where(predicate);
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      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<Predicate> filters = new LinkedList<>();
//      filters.add(cb.equal(r.get("shiftId"), shiftId));
////      filters.add(cb.equal(r.get("intRefNumber"), paxRefNum));

View Full Code Here

//    cq.where(predicate);
    
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("shiftId"), shiftId));
//      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<EntDbStaffShift> resultList = em.createQuery(cq).getResultList();
    
    if (resultList != null && resultList.size() > 0){

View Full Code Here

//    cq.where(predicate);  
    
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("idFltJobTask"), idFltJobTask));
//      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])));


    resultList = em.createQuery(cq).getResultList();
    
//    if (resultList != null && resultList.size() > 0){

View Full Code Here

      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("pKId").get("intFlId"), pKId.getIntflid()));
      filters.add(cb.equal(r.get("pKId").get("intRefNumber"), pKId.getIntrefnumber()));
//      filters.add(cb.equal(r.get("intRefNumber"), paxRefNum));  
//      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<EntDbLoadPax> resultList = em.createQuery(cq).getResultList();
    
    if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);

View Full Code Here

            Predicate subPredicate1 = criteriaBuilder.equal(from.get("oid"), f.get("oid"));
            Predicate subPredicate2 = criteriaBuilder.equal(f.get("isDeleted"), Boolean.TRUE);
            Predicate subPredicate3 = criteriaBuilder.gt(from.get("timestamp"), f.get("timestamp"));
            sub.where(criteriaBuilder.and(subPredicate1, subPredicate2, subPredicate3));


            Predicate predicate1 = criteriaBuilder.notEqual(from.get("isDeleted"), Boolean.TRUE);
            Predicate predicate2 = criteriaBuilder.exists(sub);
            query.where(predicate1, predicate2);


            TypedQuery<String> typedQuery = entityManager.createQuery(query);
            return typedQuery.getResultList();

View Full Code Here

            Predicate subPredicate1 = criteriaBuilder.le(maxTime.get("timestamp"), timestamp);
            Predicate subPredicate2 = criteriaBuilder.equal(maxTime.get("oid"), from.get("oid"));
            subquery.where(criteriaBuilder.and(subPredicate1, subPredicate2));


            Predicate predicate1 = criteriaBuilder.equal(from.get("timestamp"), subquery);
            Predicate predicate2 = criteriaBuilder.notEqual(from.get("isDeleted"), Boolean.TRUE);
            query.where(criteriaBuilder.and(predicate1, predicate2));


            TypedQuery<JPAObject> typedQuery = entityManager.createQuery(query);
            List<JPAObject> resultList = typedQuery.getResultList();

View Full Code Here

        CriteriaQuery<User> cq = cb.createQuery(User.class);
        Root<User> c = cq.from(User.class);
        Expression<String> literal = cb.literal("%" + searchstring + "%");
        Path<String> path = c.get(searchcriteria);
        Predicate predicate = cb.like(path, literal);
        Predicate condition = cb.notEqual(c.get("deleted"), true);
        cq.where(condition, predicate);
        cq.distinct(asc);
        if (asc) {
          cq.orderBy(cb.asc(c.get(orderby)));
        } else {

View Full Code Here

0 1 2 3

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.