/** * Creates a LIKE restriction for this property * * @param value The value to like compare with * * @return The LIKE restriction * * @see Restrictions#like(String, Object) */ public SimpleExpression like(Object value) { return Restrictions.like( getPropertyName(), value ); }
/** * Creates a LIKE restriction for this property * * @param value The value to like compare with * @param matchMode The match mode to apply to the LIKE * * @return The LIKE restriction * * @see Restrictions#like(String, String, MatchMode) */ public SimpleExpression like(String value, MatchMode matchMode) { return Restrictions.like( getPropertyName(), value, matchMode ); }
.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) Restrictions.disjunction() .add( Restrictions.eq( "integer", f.getInteger() ) ) .add( Restrictions.like( "string", f.getString() ) ) .add( Restrictions.eq( "boolean", f.getBoolean() ) ) Restrictions.and( Restrictions.eq( "integer", f.getInteger() ), Restrictions.like( "string", f.getString() ) ), Restrictions.eq( "boolean", f.getBoolean() ) list = s.createCriteria(Foo.class) .add( Restrictions.eq( "integer", f.getInteger() ) ) .add( Restrictions.like( "string", f.getString() ) ) .add( Restrictions.in( "boolean", f.getBoolean(), f.getBoolean() ) ) .add( Restrictions.isNotNull("foo") )
/** * @see org.openmrs.api.db.ConceptDAO#getConceptDatatypes(java.lang.String) */ @SuppressWarnings("unchecked") public List<ConceptDatatype> getConceptDatatypes(String name) throws DAOException { Criteria crit = sessionFactory.getCurrentSession().createCriteria(ConceptDatatype.class); if (name != null) { crit.add(Restrictions.like("name", name, MatchMode.START)); } return crit.list(); }
@Override public DetachedCriteria getCriteria(DetachedCriteria criteria, String key, Object value) throws QueryException { criteria.add(Restrictions.like(key, value)); return criteria; }
/** * @see SerializedObjectDAO#getAllObjects(Class, boolean) */ @Override @SuppressWarnings("unchecked") public List<SerializedObject> getAllSerializedObjects(Class<?> type, boolean includeRetired) throws DAOException { Criteria c = sessionFactory.getCurrentSession().createCriteria(SerializedObject.class); c.add(Restrictions.or(Restrictions.eq("type", type.getName()), Restrictions.eq("subtype", type.getName()))); if (!includeRetired) { c.add(Restrictions.like("retired", false)); } return (List<SerializedObject>) c.list(); }
/** * @see org.openmrs.api.db.FormDAO#getFields(java.lang.String) */ @Override @SuppressWarnings("unchecked") public List<Field> getFields(String search) throws DAOException { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Field.class); criteria.add(Restrictions.like("name", search, MatchMode.ANYWHERE)); criteria.addOrder(Order.asc("name")); return criteria.list(); }
/** * @see org.openmrs.api.db.LocationDAO#getAllLocationTags(boolean) */ @Override @SuppressWarnings("unchecked") public List<LocationTag> getAllLocationTags(boolean includeRetired) { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(LocationTag.class); if (!includeRetired) { criteria.add(Restrictions.like("retired", false)); } criteria.addOrder(Order.asc("name")); return criteria.list(); }
/** * @see org.openmrs.api.db.UserDAO#getLoginCredentialByActivationKey(java.lang.String) */ @Override public LoginCredential getLoginCredentialByActivationKey(String activationKey) { String key = Security.encodeString(activationKey); LoginCredential loginCred = (LoginCredential) sessionFactory.getCurrentSession().createCriteria(LoginCredential.class) .add(Restrictions.like("activationKey", key, MatchMode.START)).uniqueResult(); if(loginCred != null) { String[] credTokens = loginCred.getActivationKey().split(":"); if(credTokens[0].equals(key)){ return loginCred; } } return null; }
private Criterion getCriterionForLongName(String name, boolean includeVoided) { MatchMode matchMode = getMatchMode(); Criterion criterion = Restrictions.disjunction().add(Restrictions.like("name.givenName", name, matchMode)).add( Restrictions.like("name.middleName", name, matchMode)) .add(Restrictions.like("name.familyName", name, matchMode)).add( Restrictions.like("name.familyName2", name, matchMode)); if (!includeVoided) { return Restrictions.conjunction().add(Restrictions.eq("name.voided", false)).add(criterion); } return criterion; }
/** * @see org.openmrs.api.UserService#getUsersByRole(org.openmrs.Role) */ @SuppressWarnings("unchecked") public List<User> getUsersByRole(Role role) throws DAOException { return (List<User>) sessionFactory.getCurrentSession().createCriteria(User.class, "u").createCriteria("roles", "r") .add(Restrictions.like("r.role", role.getRole())).add(Restrictions.ne("u.uuid", Daemon.getDaemonUserUuid())).addOrder(Order.asc("u.username")).list(); }
criteria.add(Restrictions.or(Restrictions.eq("locale", locale), Restrictions.like("locale", language)));
@Override public String getAttorneyByAssignee(String assignee, String moduleCode) { String hql = "from Module where code='" + moduleCode + "'"; Module module = this.get(hql); if(module==null) return null; DetachedCriteria criteria = DetachedCriteria.forClass(DelegateInfo.class); criteria.add(Restrictions.eq("assignee", assignee)); Date now = new Date(); criteria.add(Restrictions.le("startTime", now)); criteria.add(Restrictions.ge("endTime", now)); criteria.add(Restrictions.like("moduleId", "%" + module.getId() + "%")); criteria.add(Restrictions.eq("deleted", 0)); List<DelegateInfo> delegateInfos = this.findByCriteria(criteria); if (delegateInfos.isEmpty()) { return null; } else { return delegateInfos.get(0).getAttorney(); } }
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; }
private Criteria getSearchAppCriteria(Integer orgId, String searchString) { Criteria criteria = getActiveAppCriteria(); criteria.add(Restrictions.eq("team.id", orgId)); if (searchString != null && !searchString.isEmpty()){ criteria.add(Restrictions.like("name", "%" + searchString + "%")); } return criteria; }
/** * @inheritDoc */ public List<String> getShortLabelsLike(String labelLike) { return getSession().createCriteria(getEntityClass()) .add(Restrictions.like("shortLabel", labelLike)) .setProjection(Projections.property("shortLabel")).list(); }
/** * @inheritDoc */ public List<String> getShortLabelsLike(String labelLike) { return getSession().createCriteria(getEntityClass()) .add(Restrictions.like("shortLabel", labelLike)) .setProjection(Projections.property("shortLabel")).list(); } }