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(); } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(SiteActivityImpl.class) .add(Expression.eq("siteId", siteId)) .add(Expression.in("eventId", events)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(ReportDef.class); if(siteId != null) { if(includedPredefined) { c.add(Expression.or(Expression.eq("siteId", siteId), Expression.isNull("siteId"))); }else{ c.add(Expression.eq("siteId", siteId)); } }else{ c.add(Expression.isNull("siteId")); } if(!includeHidden) { c.add(Expression.eq("hidden", false)); } return c.list(); } };
Disjunction disjunction = Expression.disjunction(); if (i + 50 > gradingIdList.size()) { tempList = gradingIdList.subList(i, gradingIdList.size()); disjunction.add(Expression.in("assessmentGradingId", tempList)); } else { tempList = gradingIdList.subList(i, i + 50); disjunction.add(Expression.in("assessmentGradingId", tempList)); Criterion pubCriterion = Expression.eq("publishedItemId", itemId); criteria.add(Expression.and(pubCriterion, disjunction));
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(SiteVisitsImpl.class) .add(Expression.eq("siteId", siteId)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
Disjunction disjunction = Expression.disjunction(); if (i + 50 > itemGradingIdList.size()) { tempList = itemGradingIdList.subList(i, itemGradingIdList.size()); disjunction.add(Expression.in("itemGradingData.itemGradingId", tempList)); } else { tempList = itemGradingIdList.subList(i, i + 50); disjunction.add(Expression.in("itemGradingData.itemGradingId", tempList));
Junction junction = Expression.conjunction(); // AND if (! search.conjunction) { junction = Expression.disjunction(); // OR
Disjunction disjunction = Expression.disjunction(); if (i + 50 > gradingIdList.size()) { tempList = gradingIdList.subList(i, gradingIdList.size()); disjunction.add(Expression.in("assessmentGradingId", tempList)); } else { tempList = gradingIdList.subList(i, i + 50); disjunction.add(Expression.in("assessmentGradingId", tempList)); Criterion pubCriterion = Expression.eq("publishedItemId", itemId); criteria.add(Expression.and(pubCriterion, disjunction));
public int getChannelMessagesCount(ChatChannel channel, String context, Date date) { if (channel == null) { // default to the first one List<ChatChannel> channels = getContextChannels(context, true); if (channels != null && channels.size() > 0) { channel = channels.iterator().next(); } } int count = 0; if (channel != null) { Criteria c = this.getSession().createCriteria(ChatMessage.class); c.add(Expression.eq("chatChannel", channel)); if (date != null) { c.add(Expression.ge("messageDate", date)); } c.setProjection(Projections.rowCount()); Integer countInt = (Integer) c.uniqueResult(); if (countInt != null) { count = countInt.intValue(); } } return count; }
Disjunction disjunction = Expression.disjunction(); if (i + 50 > itemGradingIdList.size()) { tempList = itemGradingIdList.subList(i, itemGradingIdList.size()); disjunction.add(Expression.in("itemGradingData.itemGradingId", tempList)); } else { tempList = itemGradingIdList.subList(i, i + 50); disjunction.add(Expression.in("itemGradingData.itemGradingId", tempList));
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria c = session.createCriteria(ResourceStatImpl.class) .add(Expression.eq("siteId", siteId)); if(!showAnonymousAccessEvents) c.add(Expression.ne("userId", "?")); if(userIdList != null && userIdList.size() > 0) c.add(Expression.in("userId", userIdList)); if(iDate != null) c.add(Expression.ge("date", iDate)); if(fDate != null){ // adjust final date Calendar ca = Calendar.getInstance(); ca.setTime(fDate); ca.add(Calendar.DAY_OF_YEAR, 1); Date fDate2 = ca.getTime(); c.add(Expression.lt("date", fDate2)); } return c.list(); } };
public Object doInHibernate(Session session) throws HibernateException, SQLException { Criteria crit = session.createCriteria(SyllabusDataImpl.class) .add(Expression.eq("syllabusItem.surrogateKey", syllabusId)) .add(Expression.eq("status", "posted")) .add(Expression.eq("linkCalendar", true)); return crit.list(); } };