Example usage for org.hibernate.criterion Restrictions isNotNull

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions isNotNull.

Prototype

public static Criterion isNotNull(String propertyName)

Source Link

Document

Apply an "is not null" constraint to the named property

Usage

From source file:fr.mcc.ginco.dao.hibernate.ThesaurusConceptDAO.java

License:CeCILL license

@Override
public Long countConceptsAlignedToIntThes(String idThesaurus) throws BusinessException {
    DetachedCriteria alignmentCriteria = DetachedCriteria.forClass(Alignment.class, "al")
            .add(Restrictions.isNotNull("al.internalTargetThesaurus")).setProjection(
                    Projections.projectionList().add(Projections.property("al.sourceConcept.identifier")));

    DetachedCriteria conceptCriteria = DetachedCriteria.forClass(ThesaurusConcept.class, "stc")
            .add(Restrictions.eq("stc.thesaurus.identifier", idThesaurus))
            .setProjection(Projections.projectionList().add(Projections.property("stc.identifier")));

    Criteria criteria = getCurrentSession().createCriteria(ThesaurusConcept.class, "tc")
            .add(Restrictions.and(Subqueries.propertyIn("tc.identifier", alignmentCriteria),
                    Subqueries.propertyIn("tc.identifier", conceptCriteria)))
            .setProjection(Projections.rowCount());

    return (Long) criteria.list().get(0);
}

From source file:fr.mcc.ginco.dao.hibernate.ThesaurusConceptDAO.java

License:CeCILL license

@Override
public Long countConceptsAlignedToExtThes(String idThesaurus) throws BusinessException {
    DetachedCriteria alignmentCriteria = DetachedCriteria.forClass(Alignment.class, "al")
            .add(Restrictions.isNotNull("al.externalTargetThesaurus")).setProjection(
                    Projections.projectionList().add(Projections.property("al.sourceConcept.identifier")));

    DetachedCriteria conceptCriteria = DetachedCriteria.forClass(ThesaurusConcept.class, "stc")
            .add(Restrictions.eq("stc.thesaurus.identifier", idThesaurus))
            .setProjection(Projections.projectionList().add(Projections.property("stc.identifier")));

    Criteria criteria = getCurrentSession().createCriteria(ThesaurusConcept.class, "tc")
            .add(Restrictions.and(Subqueries.propertyIn("tc.identifier", alignmentCriteria),
                    Subqueries.propertyIn("tc.identifier", conceptCriteria)))
            .setProjection(Projections.rowCount());
    return (Long) criteria.list().get(0);
}

From source file:fr.mcc.ginco.dao.hibernate.ThesaurusTermDAO.java

License:CeCILL license

@Override
public Long countPreferredTerms(String idThesaurus) throws BusinessException {
    Criteria criteria = getCurrentSession().createCriteria(ThesaurusTerm.class);
    criteria.add(Restrictions.eq(THESAURUS_IDENTIFIER, idThesaurus)).add(Restrictions.isNotNull(CONCEPT))
            .add(Restrictions.eq(PREFERED, Boolean.TRUE)).setProjection(Projections.rowCount());
    return (Long) criteria.list().get(0);
}

From source file:fr.mcc.ginco.dao.hibernate.ThesaurusTermDAO.java

License:CeCILL license

@Override
public Long countNonPreferredTerms(String idThesaurus) throws BusinessException {
    Criteria criteria = getCurrentSession().createCriteria(ThesaurusTerm.class);
    criteria.add(Restrictions.eq(THESAURUS_IDENTIFIER, idThesaurus)).add(Restrictions.isNotNull(CONCEPT))
            .add(Restrictions.eq(PREFERED, Boolean.FALSE)).setProjection(Projections.rowCount());
    return (Long) criteria.list().get(0);
}

From source file:fr.mcc.ginco.dao.hibernate.ThesaurusTermDAO.java

License:CeCILL license

@Override
public List<ThesaurusTerm> findPaginatedPreferredItems(Integer startIndex, Integer limit, String idThesaurus) {
    Criteria criteria = getCurrentSession().createCriteria(ThesaurusTerm.class);
    criteria.setMaxResults(limit).add(Restrictions.eq(THESAURUS_IDENTIFIER, idThesaurus))
            .add(Restrictions.isNotNull(CONCEPT)).add(Restrictions.eq(PREFERED, true))
            .setFirstResult(startIndex).addOrder(Order.asc(LEXICAL_VALUE));
    return criteria.list();
}

From source file:fsl.ta.toms.roms.dao.impl.RoadCompliancyDAOImpl.java

@Override
public Integer getTotalROMSOffences(String trn, String dln, String... plateNumber) {

    if (trn == null && dln == null && plateNumber == null) {
        return null;
    }//  w w w.j  a  va2  s  . c  o  m
    Criteria criteria = this.hibernateTemplate.getSessionFactory().getCurrentSession()
            .createCriteria(ROMS_CitationOffenceView.class, "roms_cit_view");

    if (trn != null && dln != null) {
        criteria.add(Restrictions.or(Restrictions.eq("trnNbr", trn).ignoreCase(),
                Restrictions.eq("dlNo", dln).ignoreCase()));
    } else if (trn != null) {
        criteria.add(Restrictions.eq("trnNbr", trn).ignoreCase());
    } else if (dln != null) {
        criteria.add(Restrictions.eq("dlNo", dln).ignoreCase());
    } else if (plateNumber != null && plateNumber[0] != null) {
        criteria.add(Restrictions.eq("plateNumber", plateNumber[0]).ignoreCase());
    }

    //Case restriction based on discrepancy 212 - This allows correct total count to be returned by not counting documents other than summons
    criteria.add(Restrictions.isNotNull("caseStatus"));
    criteria.setProjection(Projections.rowCount());

    return (Integer) criteria.uniqueResult();

}

From source file:gov.nih.nci.caintegrator.data.CaIntegrator2DaoImpl.java

License:BSD License

/**
 * {@inheritDoc}/*from  w  w  w  . ja va2  s  .c  om*/
 */
@Override
@SuppressWarnings(UNCHECKED)
public List<Platform> retrievePlatformsForGenomicSource(GenomicDataSourceConfiguration genomicSource) {
    Criteria arrayCriteria = getCurrentSession().createCriteria(Array.class);
    arrayCriteria.setProjection(Projections.distinct(Projections.property(PLATFORM_ASSOCIATION)))
            .add(Restrictions.isNotNull(PLATFORM_ASSOCIATION)).createCriteria("sampleCollection")
            .add(Restrictions.eq("genomicDataSource", genomicSource));

    return arrayCriteria.list();
}

From source file:gov.nih.nci.firebird.service.annual.registration.RegistrationWithdrawalServiceBean.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
public List<FirebirdUser> getAllInvestigatorsWithPendingWithdrawalRequests() {
    return sessionProvider.get().createCriteria(FirebirdUser.class)
            .add(Restrictions.isNotNull("investigatorRole.withdrawalRequest.explanation"))
            .add(Restrictions.not(Restrictions.eq("investigatorRole.status", InvestigatorStatus.WITHDRAWN)))
            .list();/*from   ww  w . j ava 2 s .  c o m*/
}

From source file:gov.nih.nci.firebird.service.GenericDataRetrievalServiceBean.java

License:Open Source License

@SuppressWarnings({ "unchecked", "rawtypes" })
// Hibernate only returns untyped results
@Override//from   w  ww  . ja  va2s.  co m
public <T extends RankableListItem> List<T> getAllRanked(Class<T> toClass) {
    List objects = sessionProvider.get().createCriteria(toClass).add(Restrictions.isNotNull("sortRanking"))
            .addOrder(Order.asc("sortRanking")).setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY).list();
    return objects;
}

From source file:gov.nih.nci.firebird.service.protocol.FormTypeServiceBean.java

License:Open Source License

@Override
@SuppressWarnings("unchecked")
// Hibernate list() method is untyped
public List<FormType> getStandardConfigureableForms(RegistrationType registrationType) {
    List<FormType> allConfigurableForms = getSession().createCriteria(FormType.class)
            .add(Restrictions.isNotNull(FORM_TYPE_ENUM_PROP))
            .add(Restrictions.ne(INV_OPTIONALITY_ENUM_PROP, FormOptionality.SUPPLEMENTARY))
            .add(Restrictions.ne(SUBINV_OPTIONALITY_ENUM_PROP, FormOptionality.SUPPLEMENTARY)).list();
    filterByType(allConfigurableForms, registrationType);
    return allConfigurableForms;
}