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

            + searchstring + "%");
        // crit.add(Restrictions.ilike(searchcriteria, "%" +
        // 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

        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

        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

        Root<SiteImpl> site = criteria.from(SiteImpl.class);
        criteria.select(site);
        criteria.where(
            builder.and(
                builder.or(builder.isNull(site.get("archiveStatus").get("archived").as(String.class)),
                    builder.notEqual(site.get("archiveStatus").get("archived").as(Character.class), 'Y')),
                builder.or(builder.isNull(site.get("deactivated").as(Boolean.class)),
                    builder.notEqual(site.get("deactivated").as(Boolean.class), true))
            )
        );

View Full Code Here

        criteria.where(
            builder.and(
                builder.or(builder.isNull(site.get("archiveStatus").get("archived").as(String.class)),
                    builder.notEqual(site.get("archiveStatus").get("archived").as(Character.class), 'Y')),
                builder.or(builder.isNull(site.get("deactivated").as(Boolean.class)),
                    builder.notEqual(site.get("deactivated").as(Boolean.class), true))
            )
        );
        
        TypedQuery<Site> query = em.createQuery(criteria);
        query.setHint(QueryHints.HINT_CACHEABLE, true);

View Full Code Here

      if (HpUfisUtils.isNotEmptyStr(params.getFlda())) {
        filters.add(cb.equal(root.<String> get("flda"),
            params.getFlda()));
      }
      if (params.getAdid() != null) {
        filters.add(cb.notEqual(root.<Character> get("adid"),
            'B'));
      }
      filters.add(cb.not(cb.in(root.get("ftyp")).value('T').value('G')
          .value('X').value('N')));

View Full Code Here

       
//       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);

View Full Code Here

   //  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

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

View Full Code Here

     Root<EntDbLoadPaxX> r = cq.from(EntDbLoadPaxX.class);
    cq.select(r);
      List<Predicate> filters = new LinkedList<>();
      filters.add(cb.equal(r.get("uuid"),uuid));


      filters.add(cb.notEqual(r.get("_recStatus"),"X"));
    cq.where(cb.and(filters.toArray(new Predicate[0])));
    List<EntDbLoadPaxX> resultList = em.createQuery(cq).getResultList();
    
    if (resultList != null && resultList.size() > 0){
      result = resultList.get(0);

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.