Refine search
.add( Restrictions.eq( "integer", f.getInteger() ) ) .add( Restrictions.eqProperty("integer", "integer") ) .add( Restrictions.like( "string", f.getString().toUpperCase(Locale.ROOT) ).ignoreCase() ) .add( Restrictions.in( "boolean", f.getBoolean(), f.getBoolean() ) ) .setFetchMode("foo", FetchMode.JOIN) list = s.createCriteria(Foo.class).add( Restrictions.disjunction() .add( Restrictions.eq( "integer", f.getInteger() ) ) .add( Restrictions.like( "string", f.getString() ) ) .add( Restrictions.eq( "boolean", f.getBoolean() ) )
/** * Group expressions together in a single disjunction (A or B or C...). * * This form creates an empty disjunction. See {@link Disjunction#add(Criterion)} * * @return Conjunction */ public static Disjunction disjunction() { return new Disjunction(); }
protected Criteria partnersByAcCriteria( String ac ) { if ( ac == null ) { throw new NullPointerException( "ac" ); } return getSession().createCriteria( InteractorImpl.class ) .add( Restrictions.idEq( ac ) ) .createAlias( "activeInstances", "comp" ) .createAlias( "comp.interaction", "int" ) .createAlias( "int.components", "intcomp" ) .createAlias( "intcomp.interactor", "prot" ) .add( Restrictions.disjunction() .add( Restrictions.ne( "prot.ac", ac ) ) .add( Restrictions.eq( "comp.stoichiometry", 2f ) ) ); }
private void buildCriteria(Criteria criteria,boolean queryCount){ if(!queryCount && firstResult>0){ criteria.setFirstResult(firstResult); criteria.setMaxResults(maxResults); criteria.add(Restrictions.eq("processId",processId)); }else{ criteria.add(Restrictions.in("processId",processIds)); criteria.add(Restrictions.eq("owner", owner)); Disjunction disjunction=Restrictions.disjunction(); for(String user:participators){ disjunction.add(Restrictions.eq("user",user)); participatorCriteria.add(disjunction);
disjunction.add(Restrictions.like( parameterName, stringParameterValues[index], matchMode)); disjunction.add(Restrictions .isNull(parameterName)); disjunction.add(Restrictions.like( parameterName, parameterValues[index])); disjunction.add(Restrictions disjunction.add(Restrictions.ilike( parameterName, stringParameterValues[index], matchMode)); disjunction.add(Restrictions disjunction.add(Restrictions.ilike( parameterName, parameterValues[index])); disjunction.add(Restrictions disjunction.add(Restrictions.eq(parameterName, parameterValues[index])); disjunction.add(Restrictions.isNull(parameterName)); disjunction.add(Restrictions.ge(parameterName, parameterValues[index]));
/** * Creates or that matches the input name with Provider-Person-Names (not voided) * * @param name * @return Junction */ private Junction getNameSearchExpression(String name) { MatchMode mode = MatchMode.ANYWHERE; Conjunction and = Restrictions.conjunction(); and.add(Restrictions.eq("personName.voided", false)); Disjunction or = Restrictions.disjunction(); and.add(or); or.add(Restrictions.ilike("personName.givenName", name, mode)); or.add(Restrictions.ilike("personName.middleName", name, mode)); or.add(Restrictions.ilike("personName.familyName", name, mode)); or.add(Restrictions.ilike("personName.familyName2", name, mode)); return and; }
/** * @see org.openmrs.api.db.OrderDAO#getActiveOrders(org.openmrs.Patient, java.util.List, * org.openmrs.CareSetting, java.util.Date) */ @Override @SuppressWarnings("unchecked") public List<Order> getActiveOrders(Patient patient, List<OrderType> orderTypes, CareSetting careSetting, Date asOfDate) { Criteria crit = createOrderCriteria(patient, careSetting, orderTypes, false, false); crit.add(Restrictions.le("dateActivated", asOfDate)); Disjunction dateStoppedAndAutoExpDateDisjunction = Restrictions.disjunction(); Criterion stopAndAutoExpDateAreBothNull = Restrictions.and(Restrictions.isNull("dateStopped"), Restrictions .isNull("autoExpireDate")); dateStoppedAndAutoExpDateDisjunction.add(stopAndAutoExpDateAreBothNull); Criterion autoExpireDateEqualToOrAfterAsOfDate = Restrictions.and(Restrictions.isNull("dateStopped"), Restrictions .ge("autoExpireDate", asOfDate)); dateStoppedAndAutoExpDateDisjunction.add(autoExpireDateEqualToOrAfterAsOfDate); dateStoppedAndAutoExpDateDisjunction.add(Restrictions.ge("dateStopped", asOfDate)); crit.add(dateStoppedAndAutoExpDateDisjunction); return crit.list(); }
Disjunction dis = Restrictions.disjunction(); for (Long l : getChildren (acct)) { hasChildren = true; dis.add (Restrictions.idEq(l)); Criteria subCrit = crit.createCriteria(("account")); subCrit.add (dis); crit.add (Restrictions.eq ("account", acct));
/** * @see org.openmrs.api.db.CohortDAO#getCohortsContainingPatientId(Integer, boolean, Date) */ @Override @SuppressWarnings("unchecked") public List<Cohort> getCohortsContainingPatientId(Integer patientId, boolean includeVoided, Date asOfDate) throws DAOException { Disjunction orEndDate = Restrictions.disjunction(); orEndDate.add(Restrictions.isNull("m.endDate")); orEndDate.add(Restrictions.gt("m.endDate", asOfDate)); Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Cohort.class); criteria.createAlias("memberships", "m"); if (asOfDate != null) { criteria.add(Restrictions.le("m.startDate", asOfDate)); criteria.add(orEndDate); } criteria.add(Restrictions.eq("m.patientId", patientId)); criteria.setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY); if (!includeVoided) { criteria.add(Restrictions.eq(VOIDED, includeVoided)); } return criteria.list(); }
Patient.class); criteria.createAlias("names", "name"); criteria.createAlias("attributes", "att"); criteria.createAlias("identifiers", "id"); criteria.add(Restrictions.eq("voided", false)); criteria.add(Restrictions.eq("name.voided", false)); criteria.add(Restrictions.eq("att.voided", false)); criteria.add(Restrictions.eq("id.voided", false)); Disjunction otherCriterion = Restrictions.disjunction(); otherCriterion.add(Restrictions.eq("birthdate", birthDate)); otherCriterion .add(Restrictions .sqlRestriction( "exists (select f.id from motechmodule_facility f " + "where f.facility_id = ? and fp.patient_id = {alias}.patient_id)", facilityId, Hibernate.INTEGER)); otherCriterion.add(phoneCriterion); Disjunction finalCriterion = Restrictions.disjunction(); finalCriterion.add(patientIdCriterion); finalCriterion.add(nhisCriterion); finalCriterion.add(Restrictions.and(nameCriterion, otherCriterion)); criteria.add(finalCriterion);
Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Provider.class).createAlias("person", "p", JoinType.LEFT_OUTER_JOIN); criteria.add(Restrictions.eq("retired", false)); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); criteria.createAlias("p.names", "personName", JoinType.LEFT_OUTER_JOIN); Disjunction or = Restrictions.disjunction(); or.add(Restrictions.ilike("identifier", name, getMatchMode())); or.add(Restrictions.ilike("name", name, MatchMode.ANYWHERE)); Conjunction and = Restrictions.conjunction(); or.add(and);
private void addEmptyVisitsByPatientCriteria(Criteria criteria, Patient patient, boolean includeVoided, String query) { criteria.add(Restrictions.eq("patient", patient)); criteria.add(Restrictions.isEmpty("encounters")); if (!includeVoided) { criteria.add(Restrictions.eq("voided", includeVoided)); } if (query != null && !StringUtils.isBlank(query)) { criteria.createAlias("visitType", "visitType", JoinType.LEFT_OUTER_JOIN); criteria.createAlias("location", "location", JoinType.LEFT_OUTER_JOIN); Disjunction or = Restrictions.disjunction(); criteria.add(or); or.add(Restrictions.ilike("visitType.name", query, MatchMode.ANYWHERE)); or.add(Restrictions.ilike("location.name", query, MatchMode.ANYWHERE)); } criteria.addOrder(Order.desc("startDatetime")); criteria.addOrder(Order.desc("visitId")); }
Criteria processCrit = crit.createCriteria("process"); Disjunction disj = Restrictions.disjunction(); for (String pid: pids) { if( !filter.arePidsNegative() ) { disj.add(Restrictions.eq("processId", pid)); } else { disj.add(Restrictions.ne("processId", pid)); processCrit.add(disj); Disjunction disj = Restrictions.disjunction(); for (String iid: iids) { disj.add(Restrictions.eq("id", new Long(iid))); crit.add(disj); Disjunction disj = Restrictions.disjunction(); for (short status : statuses) { disj.add(Restrictions.eq("state", status)); crit.add(disj);
Criteria cr = session.createCriteria(Item.class); Criterion price = Restrictions.gt("initial price", 22); Criterion name = Restrictions.eq("seller.id","abc"); Criterion Buyer = Restrictions.eq("buyer.id","abc"); Criterion reserved_price = Restrictions.eq("reserved_price","initial_price"); Disjunction objDisjunction = Restrictions.disjunction(); /* Add multiple condition separated by OR clause within brackets. */ objDisjunction.add(Restrictions.and(price , name )); objDisjunction.add(Restrictions.and(Buyer, reserved_price)); cr.add(objDisjunction); List results = cr.list();
criteria.add(Restrictions.conjunction().add(prepareCriterionForName(query, null, includeVoided)).add( Restrictions.not(prepareCriterionForName(query, true, includeVoided))).add( Restrictions.not(prepareCriterionForName(query, false, includeVoided)))); } else if (!matchExactly) { criteria.add(prepareCriterionForName(query, false, includeVoided)); } else { personSearchCriteria.addAliasForAttribute(criteria); addAliasForIdentifiers(criteria); criteria.add(Restrictions.disjunction().add(prepareCriterionForName(query, true, includeVoided)).add( prepareCriterionForAttribute(query, includeVoided)).add( prepareCriterionForIdentifier(query, new ArrayList<>(), false, includeVoided)));
public Object doInHibernate(Session session) throws HibernateException, SQLException { final Criteria c = session.createCriteria(SakaiPersonImpl.class); c.add(Expression.disjunction().add(Expression.ilike(UID, match)).add(Expression.ilike(GIVENNAME, match)).add( Expression.ilike(SURNAME, match))); c.addOrder(Order.asc(SURNAME)); // c.setCacheable(cacheFindSakaiPersonString); return c.list(); } };
if (firstExpressionIsRequiredBoolean()) { GrailsMethodExpression expression = (GrailsMethodExpression) expressions.remove(0); c.add(expression.getCriterion()); Disjunction dis = Restrictions.disjunction(); int numberOfForceNoResultsCriterion = 0; for (Object expression : expressions) { numberOfForceNoResultsCriterion++; } else { dis.add(current.getCriterion()); return Collections.EMPTY_LIST; c.add(dis); return Collections.emptyList(); c.add(current.getCriterion());
private Criterion getCriterionForNoExactName(String name, boolean includeVoided) { MatchMode matchMode = getMatchMode(); Criterion criterion = Restrictions.conjunction().add( Restrictions.disjunction().add( Restrictions.conjunction().add(Restrictions.isNotNull("name.givenName")).add( Restrictions.like("name.givenName", name, matchMode))).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.middleName")).add( Restrictions.like("name.middleName", name, matchMode))).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.familyName")).add( Restrictions.like("name.familyName", name, matchMode))).add( Restrictions.conjunction().add(Restrictions.isNotNull("name.familyName2")).add( Restrictions.like("name.familyName2", name, matchMode)))).add( Restrictions.disjunction().add(Restrictions.isNull("name.givenName")).add( Restrictions.ne("name.givenName", name))).add( Restrictions.disjunction().add(Restrictions.isNull("name.middleName")).add( Restrictions.ne("name.middleName", name))).add( Restrictions.disjunction().add(Restrictions.isNull("name.familyName")).add( Restrictions.ne("name.familyName", name))).add( Restrictions.disjunction().add(Restrictions.isNull("name.familyName2")).add( Restrictions.ne("name.familyName2", name))); if (!includeVoided) { return Restrictions.conjunction().add(Restrictions.eq("name.voided", false)).add(criterion); } return criterion; }