Java Code Examples for org.hibernate.criterion.Restrictions#in()
The following examples show how to use
org.hibernate.criterion.Restrictions#in() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: CriteriaParameter.java From Knowage-Server with GNU Affero General Public License v3.0 | 6 votes |
public Criterion toHibernateCriterion() { Criterion restriction = null; switch (getMatch()) { case LIKE: restriction = Restrictions.like(getName(), (String) getValue(), MatchMode.ANYWHERE); break; case ILIKE: restriction = Restrictions.like(getName(), (String) getValue(), MatchMode.ANYWHERE).ignoreCase(); break; case NOT_EQ: restriction = Restrictions.ne(getName(), getValue()); break; case IN: restriction = Restrictions.in(getName(), (Object[]) getValue()); break; case NOT_IN: restriction = Restrictions.not(Restrictions.in(getName(), (Object[]) getValue())); break; default: restriction = Restrictions.eq(getName(), getValue()); break; } return restriction; }
Example 2
Source File: JobDaoImpl.java From ctsms with GNU Lesser General Public License v2.1 | 6 votes |
@Override protected Collection<Job> handleFindPending(Long departmentId, Boolean daily, Boolean weekly, Boolean monthly) throws Exception { org.hibernate.Criteria jobCriteria = createJobCriteria(); if (departmentId != null) { jobCriteria.createCriteria("modifiedUser").add(Restrictions.eq("department.id", departmentId.longValue())); } if (daily != null || weekly != null || monthly != null) { org.hibernate.Criteria typeCriteria = jobCriteria.createCriteria("type"); if (daily != null) { typeCriteria.add(Restrictions.eq("daily", daily.booleanValue())); } if (weekly != null) { typeCriteria.add(Restrictions.eq("weekly", weekly.booleanValue())); } if (monthly != null) { typeCriteria.add(Restrictions.eq("monthly", monthly.booleanValue())); } } Restrictions.in("status", new Object[] { JobStatus.CREATED, JobStatus.FAILED, JobStatus.OK }); jobCriteria.addOrder(Order.asc("id")); return jobCriteria.list(); }
Example 3
Source File: HibernateCriterionUtils.java From sakai with Educational Community License v2.0 | 6 votes |
public static Criterion CriterionInRestrictionSplitter(String property, Collection<?> values) { Objects.requireNonNull(property); Objects.requireNonNull(values); Criterion criterion = null; List<?> list = new ArrayList<>(values); int listSize = list.size(); for (int i = 0; i < listSize; i += MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST) { List<?> subList; if (listSize > i + MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST) { subList = list.subList(i, (i + MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST)); } else { subList = list.subList(i, listSize); } if (criterion == null) { criterion = Restrictions.in(property, subList); } else { criterion = Restrictions.or(criterion, Restrictions.in(property, subList)); } } return criterion; }
Example 4
Source File: HibernateCriterionUtils.java From sakai with Educational Community License v2.0 | 6 votes |
public static Criterion CriterionInRestrictionSplitter(String property, Collection<?> values) { Objects.requireNonNull(property); Objects.requireNonNull(values); Criterion criterion = null; List<?> list = new ArrayList<>(values); int listSize = list.size(); for (int i = 0; i < listSize; i += MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST) { List<?> subList; if (listSize > i + MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST) { subList = list.subList(i, (i + MAX_NUMBER_OF_SQL_PARAMETERS_IN_LIST)); } else { subList = list.subList(i, listSize); } if (criterion == null) { criterion = Restrictions.in(property, subList); } else { criterion = Restrictions.or(criterion, Restrictions.in(property, subList)); } } return criterion; }
Example 5
Source File: InOperator.java From dhis2-core with BSD 3-Clause "New" or "Revised" License | 5 votes |
@Override public Criterion getHibernateCriterion( QueryPath queryPath ) { Property property = queryPath.getProperty(); if ( property.isCollection() ) { return Restrictions.in( queryPath.getPath(), getValue( Collection.class, queryPath.getProperty().getItemKlass(), args.get( 0 ) ) ); } return Restrictions.in( queryPath.getPath(), getValue( Collection.class, queryPath.getProperty().getKlass(), args.get( 0 ) ) ); }
Example 6
Source File: CriteriaVisitor.java From geomajas-project-server with GNU Affero General Public License v3.0 | 5 votes |
/** {@inheritDoc} */ @Override public Object visit(Id filter, Object userData) { String idName; try { idName = featureModel.getEntityMetadata().getIdentifierPropertyName(); } catch (LayerException e) { log.warn("Cannot read idName, defaulting to 'id'", e); idName = HIBERNATE_ID; } Collection<?> c = (Collection<?>) castLiteral(filter.getIdentifiers(), idName); return Restrictions.in(idName, c); }
Example 7
Source File: DocumentResourceFacadeImp.java From AIDR with GNU Affero General Public License v3.0 | 5 votes |
@Override public List<DocumentDTO> getDocumentForNominalLabelAndCrisis(List<Long> nominalLabelID, Long crisisId) { List<DocumentDTO> dtoList = new ArrayList<DocumentDTO>(); if (nominalLabelID != null) { String aliasTable = "documentNominalLabels"; String aliasTableKeyField = "documentNominalLabels.id.nominalLabelId"; Criteria criteria = null; try { Criterion criterion = Restrictions.conjunction() .add(Restrictions.eq("collection.id", crisisId)) .add(Restrictions.eq("hasHumanLabels", true)); Criterion aliasCriterion = Restrictions.in(aliasTableKeyField, nominalLabelID); // get just the documentIDs Projection projection = Projections.property("documentId"); //List<Document> docList = this.getByCriteriaWithInnerJoinByOrder(criterion, "DESC", orderBy, null, aliasTable, aliasCriterion); criteria = createCriteria(criterion, null, null, null, aliasTable, aliasCriterion, null, JoinType.INNER_JOIN); List<Document> docList = criteria.list(); if (docList != null && !docList.isEmpty()) { for (Document doc : docList) { DocumentDTO dto = new DocumentDTO(doc); dtoList.add(dto); } } } catch (Exception e) { logger.error("getDocumentCountForNominalLabelAndCrisis failed, criteria = " + criteria.toString(), e); } } return dtoList; }
Example 8
Source File: DrugsDAOImpl.java From freehealth-connector with GNU Affero General Public License v3.0 | 4 votes |
private Criterion getTypesCriterion(List<String> types) { return Restrictions.in("type", types); }
Example 9
Source File: DrugsDAOImpl.java From icure-backend with GNU General Public License v2.0 | 4 votes |
private Criterion getTypesCriterion(List<String> types) { return Restrictions.in("type", types); }
Example 10
Source File: BookDao.java From projectforge-webapp with GNU General Public License v3.0 | 4 votes |
@Override public List<BookDO> getList(final BaseSearchFilter filter) { final BookFilter myFilter; if (filter instanceof BookFilter) { myFilter = (BookFilter) filter; } else { myFilter = new BookFilter(filter); } final QueryFilter queryFilter = new QueryFilter(myFilter); if (StringUtils.isBlank(myFilter.getSearchString()) == true) { Collection<BookStatus> col = null; if (myFilter.isPresent() == true || myFilter.isMissed() == true || myFilter.isDisposed() == true) { col = new ArrayList<BookStatus>(); if (myFilter.isPresent() == true) { // Book must be have status 'present'. col.add(BookStatus.PRESENT); } if (myFilter.isMissed() == true) { // Book must be have status 'missed'. col.add(BookStatus.MISSED); } if (myFilter.isDisposed() == true) { // Book must be have status 'disposed'. col.add(BookStatus.DISPOSED); } } myFilter.setIgnoreDeleted(false); if (col != null) { final Criterion inCrit = Restrictions.in("status", col); if (myFilter.isDeleted() == true) { queryFilter.add(Restrictions.or(inCrit, Restrictions.eq("deleted", true))); myFilter.setIgnoreDeleted(true); } else { queryFilter.add(inCrit); } } } queryFilter.addOrder(Order.desc("created")); queryFilter.addOrder(Order.asc("authors")); return getList(queryFilter); }
Example 11
Source File: InRestriction.java From base-framework with Apache License 2.0 | 4 votes |
public Criterion buildRestriction(String propertyName, Object[] values) { return Restrictions.in(propertyName,values); }
Example 12
Source File: HibernateGenericDao.java From lemon with Apache License 2.0 | 3 votes |
/** * find by ids. * * @param entityClass * Class * @param ids * List * @param <T> * generic * @return List */ @Transactional(readOnly = true) public <T> List<T> findByIds(Class<T> entityClass, List ids) { Assert.notEmpty(ids); String idName = this.getIdName(entityClass); Criterion criterion = Restrictions.in(idName, ids); return this.find(entityClass, criterion); }
Example 13
Source File: HibernateUtils.java From lemon with Apache License 2.0 | 2 votes |
/** * 按属性条件参数创建Criterion,辅助函数. * * @param propertyName * String * @param propertyValue * Object * @param matchType * MatchType * @return Criterion */ public static Criterion buildCriterion(String propertyName, Object propertyValue, MatchType matchType) { Assert.hasText(propertyName, "propertyName不能为空"); Criterion criterion = null; // 根据MatchType构造criterion switch (matchType) { case EQ: criterion = Restrictions.eq(propertyName, propertyValue); break; case NOT: criterion = Restrictions.ne(propertyName, propertyValue); break; case LIKE: criterion = Restrictions.like(propertyName, (String) propertyValue, MatchMode.ANYWHERE); break; case LE: criterion = Restrictions.le(propertyName, propertyValue); break; case LT: criterion = Restrictions.lt(propertyName, propertyValue); break; case GE: criterion = Restrictions.ge(propertyName, propertyValue); break; case GT: criterion = Restrictions.gt(propertyName, propertyValue); break; case IN: criterion = Restrictions.in(propertyName, (Collection) propertyValue); break; case INL: criterion = Restrictions.isNull(propertyName); break; case NNL: criterion = Restrictions.isNotNull(propertyName); break; default: criterion = Restrictions.eq(propertyName, propertyValue); break; } return criterion; }