/** * Creates a descending ordering for this property * * @return The order */ public Order desc() { return Order.desc( getPropertyName() ); }
public ServerBackup lastBackup() { List results = (List) getHibernateTemplate().execute((HibernateCallback) session -> { Criteria criteria = session.createCriteria(ServerBackup.class); criteria.setMaxResults(1); criteria.addOrder(Order.desc("id")); return criteria.list(); }); return results.isEmpty() ? null : (ServerBackup) results.get(0); }
@Override public EndpointProfileSchema findLatestByAppId(String appId) { EndpointProfileSchema latestSchema = null; LOG.debug("Searching latest profile schema by application id [{}] ", appId); if (isNotBlank(appId)) { Criteria criteria = getCriteria().createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS) .add(Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId))) .addOrder(Order.desc(VERSION_PROPERTY)).setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", appId, latestSchema); } else { LOG.debug("[{}] Search result: {}.", appId, latestSchema != null); } return latestSchema; }
@Override public LogSchema findLatestLogSchemaByAppId(String applicationId) { LOG.debug("Searching latest log schema by application id [{}]", applicationId); LogSchema logSchema = null; if (isNotBlank(applicationId)) { Criteria criteria = getCriteria(); criteria.createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS); Criterion criterion = Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(applicationId)); logSchema = (LogSchema) criteria.add(criterion).addOrder(Order.desc(VERSION_PROPERTY)) .setMaxResults(FIRST).uniqueResult(); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", applicationId, logSchema); } else { LOG.debug("[{}] Search result: {}.", applicationId, logSchema != null); } return logSchema; }
@Override public ConfigurationSchema findLatestByApplicationId(String appId) { ConfigurationSchema latestSchema = null; LOG.debug("Searching latest configuration schema by application id [{}] ", appId); if (isNotBlank(appId)) { Criteria criteria = getCriteria().createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS) .add(Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId))) .addOrder(Order.desc(VERSION_PROPERTY)) .setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", appId, latestSchema); } else { LOG.debug("[{}] Search result: {}.", appId, latestSchema != null); } return latestSchema; }
@Override public NotificationSchema findLatestNotificationSchemaByAppId( String appId, NotificationTypeDto type) { LOG.debug("Searching latest notification schema by application id [{}] type [{}]", appId, type); NotificationSchema latestSchema = null; if (isNotBlank(appId)) { Criteria criteria = getCriteria().add(Restrictions.and( Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId)), Restrictions.eq(NOTIFICATION_SCHEMA_TYPE_PROPERTY, type) )).addOrder(Order.desc(VERSION_PROPERTY)).setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{},{}] Search result: {}.", appId, type, latestSchema); } else { LOG.debug("[{},{}] Search result: {}.", appId, type, latestSchema != null); } return latestSchema; } }
@Override public CtlSchema findLatestByMetaInfoId(String metaInfoId) { CtlSchema latestSchema = null; LOG.debug("Searching latest version of ctl schema by meta info id [{}]", metaInfoId); if (isNotBlank(metaInfoId)) { Criteria criteria = getCriteria() .createAlias(CTL_SCHEMA_META_INFO_PROPERTY, CTL_SCHEMA_META_INFO_ALIAS) .add(Restrictions.eq(CTL_SCHEMA_META_INFO_ALIAS_ID, Long.valueOf(metaInfoId))) .addOrder(Order.desc(CTL_SCHEMA_VERSION)) .setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: [{}].", metaInfoId, latestSchema); } else { LOG.debug("[{}] Search result: [{}].", metaInfoId, latestSchema != null); } return latestSchema; }
@Override public ServerProfileSchema findLatestByAppId(String appId) { ServerProfileSchema latestSchema = null; LOG.debug("Searching latest server profile schema by application id [{}] ", appId); if (isNotBlank(appId)) { Criteria criteria = getCriteria().createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS) .add(Restrictions.eq(APPLICATION_REFERENCE, getLongId(appId))) .addOrder(Order.desc(VERSION_PROPERTY)).setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", appId, latestSchema); } else { LOG.debug("[{}] Search result: {}.", appId, latestSchema != null); } return latestSchema; }
@Override public Configuration findLatestDeprecated(String schemaId, String groupId) { Configuration configuration = null; LOG.debug("Searching latest deprecated configurations by configuration schema id [{}] " + "and group id [{}] ", schemaId, groupId); if (isNotBlank(schemaId) && isNotBlank(groupId)) { Criteria criteria = getCriteria(); criteria.createAlias(CONFIGURATION_SCHEMA_PROPERTY, CONFIGURATION_SCHEMA_ALIAS); criteria.createAlias(ENDPOINT_GROUP_PROPERTY, ENDPOINT_GROUP_ALIAS); criteria.add(Restrictions.and( Restrictions.eq(ENDPOINT_GROUP_REFERENCE, Long.valueOf(groupId)), Restrictions.eq(CONFIGURATION_SCHEMA_REFERENCE, Long.valueOf(schemaId)), Restrictions.eq(STATUS_PROPERTY, UpdateStatus.DEPRECATED))); criteria.addOrder(Order.desc(SEQUENCE_NUMBER_PROPERTY)).setMaxResults(FIRST); configuration = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{},{}] Search result: {}.", schemaId, groupId, configuration); } else { LOG.debug("[{},{}] Search result: {}.", schemaId, groupId, configuration != null); } return configuration; }
Long.valueOf(applicationId)) : Restrictions.isNull(CTL_SCHEMA_META_INFO_ALIAS_APPLICATION_ID)) ).addOrder(Order.desc(CTL_SCHEMA_VERSION)) .setMaxResults(FIRST); CtlSchema latestSchema = findOneByCriteria(criteria);
buildEqIdCriterion(SERVER_PROFILE_SCHEMA_REFERENCE, serverProfileSchemaId), Restrictions.eq(STATUS_PROPERTY, UpdateStatus.DEPRECATED)); filter = (ProfileFilter) criteria.add(crit).addOrder(Order.desc(SEQUENCE_NUMBER_PROPERTY)) .setMaxResults(FIRST).uniqueResult();
.setFirstResult(1) .addOrder( Order.asc("date") ) .addOrder( Order.desc("string") ) .list(); assertTrue( list.size() == 0 );
.addOrder( Order.desc("name") ) .list(); p = (Parent) parents.get(0);
/** * @see org.openmrs.api.db.FormDAO#getFormsByName(java.lang.String) */ @Override @SuppressWarnings("unchecked") public List<Form> getFormsByName(String name) throws DAOException { Criteria crit = sessionFactory.getCurrentSession().createCriteria(Form.class); crit.add(Restrictions.eq("name", name)); crit.add(Restrictions.eq("retired", false)); crit.addOrder(Order.desc("version")); return crit.list(); }
/** * @see org.openmrs.api.db.EncounterDAO#getEncountersByPatientId(java.lang.Integer) */ @Override @SuppressWarnings("unchecked") public List<Encounter> getEncountersByPatientId(Integer patientId) throws DAOException { Criteria crit = sessionFactory.getCurrentSession().createCriteria(Encounter.class).createAlias("patient", "p").add( Restrictions.eq("p.patientId", patientId)).add(Restrictions.eq("voided", false)).addOrder( Order.desc("encounterDatetime")); return crit.list(); }
@SuppressWarnings("unchecked") @Override public List<Encounter> getEncountersNotAssignedToAnyVisit(Patient patient) throws DAOException { return sessionFactory.getCurrentSession().createCriteria(Encounter.class).add(Restrictions.eq("patient", patient)) .add(Restrictions.isNull("visit")).add(Restrictions.eq("voided", false)).addOrder( Order.desc("encounterDatetime")).setMaxResults(100).list(); }
/** * @see org.openmrs.api.db.ConceptDAO#getPrevConcept(org.openmrs.Concept) */ @Override @SuppressWarnings("unchecked") public Concept getPrevConcept(Concept c) { Integer i = c.getConceptId(); List<Concept> concepts = sessionFactory.getCurrentSession().createCriteria(Concept.class).add( Restrictions.lt("conceptId", i)).addOrder(Order.desc("conceptId")).setFetchSize(1).list(); if (concepts.isEmpty()) { return null; } return concepts.get(0); }
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")); }
@Override public List<MessageGroup> getGroupListByIds(String groupIds) { DetachedCriteria criteria = DetachedCriteria.forClass(MessageGroup.class); String[] groupArr = groupIds.split(","); criteria.add(Restrictions.in("groupId", groupArr)); criteria.addOrder(Order.desc("sort")); return this.findByCriteria(criteria); }