Projections.projectionList() .add( Projections.groupProperty( "c.id" ) ) .add( Projections.countDistinct( "p.id" ) )
/** * @see org.openmrs.api.db.ProviderDAO#getProviderByIdentifier(java.lang.String) */ @Override public boolean isProviderIdentifierUnique(Provider provider) throws DAOException { Criteria criteria = getSession().createCriteria(Provider.class); criteria.add(Restrictions.eq("identifier", provider.getIdentifier())); if (provider.getProviderId() != null) { criteria.add(Restrictions.not(Restrictions.eq("providerId", provider.getProviderId()))); } criteria.setProjection(Projections.countDistinct("providerId")); return (Long) criteria.uniqueResult() == 0L; }
/** * @see org.openmrs.api.db.EncounterDAO#getCountOfEncounters(java.lang.String, * java.lang.Integer, boolean) */ @Override public Long getCountOfEncounters(String query, Integer patientId, boolean includeVoided) { Criteria criteria = createEncounterByQueryCriteria(query, patientId, includeVoided, false); criteria.setProjection(Projections.countDistinct("enc.encounterId")); return (Long) criteria.uniqueResult(); }
public Projection toHibernateProjection(Query.Projection gormProjection) { Query.CountDistinctProjection cd = (Query.CountDistinctProjection) gormProjection; return Projections.countDistinct(cd.getPropertyName()); } });
@Deprecated public Integer countPartnersByProteinAc( String proteinAc ) { final Long count = (Long) partnersByAcCriteria(proteinAc) .setProjection(Projections.countDistinct("prot.ac")).uniqueResult(); return count.intValue(); }
/** * Adds a projection that allows the criteria to return the distinct property count * * @param propertyName The name of the property * @param alias The alias to use */ public org.grails.datastore.mapping.query.api.ProjectionList countDistinct(String propertyName, String alias) { final CountProjection proj = Projections.countDistinct(calculatePropertyName(propertyName)); addProjectionToList(proj, alias); return this; }
@Override public org.grails.datastore.mapping.query.api.ProjectionList countDistinct(String property) { projectionList.add(Projections.countDistinct(calculatePropertyName(property))); return this; }
public Integer countComponentsForInteractorWithAc( String ac ) { final Long count = (Long) getSession().createCriteria(Component.class) .createAlias("interactor", "interactor") .add(Restrictions.eq("interactor.ac", ac)) .setProjection(Projections.countDistinct("ac")).uniqueResult(); return count.intValue(); }
public Integer countComponentsForInteractorWithAc( String ac ) { final Long count = (Long) getSession().createCriteria(Component.class) .createAlias("interactor", "interactor") .add(Restrictions.eq("interactor.ac", ac)) .setProjection(Projections.countDistinct("ac")).uniqueResult(); return count.intValue(); }
@Deprecated public Integer countPartnersByProteinAc( String proteinAc ) { final Long count = (Long) partnersByAcCriteria(proteinAc) .setProjection(Projections.countDistinct("prot.ac")).uniqueResult(); return count.intValue(); }
@Nonnull public Long countVersions(@Nonnull Long codForm) { return (Long) getSession() .createCriteria(FormVersionEntity.class) .createAlias("formEntity", "formEntity") .add(Restrictions.eq("formEntity.cod", codForm)) .setProjection(Projections.countDistinct("cod")) .setMaxResults(1) .uniqueResult(); } }
@Nonnull public Long countVersions(@Nonnull Long codForm) { return (Long) getSession() .createCriteria(FormVersionEntity.class) .createAlias("formEntity", "formEntity") .add(Restrictions.eq("formEntity.cod", codForm)) .setProjection(Projections.countDistinct("cod")) .setMaxResults(1) .uniqueResult(); } }
public Integer countComponentsForInteractorWithAc( String ac ) { return ( Integer ) getSession().createCriteria( Component.class ) .createAlias( "interactor", "interactor" ) .add( Restrictions.eq( "interactor.ac", ac ) ) .setProjection( Projections.countDistinct( "ac" ) ).uniqueResult(); }
public Integer countInteractionsForInteractorWithAc( String ac ) { final Long count = (Long) getSession().createCriteria(Component.class) .createAlias("interactor", "interactor") .createAlias("interaction", "interaction") .add(Restrictions.eq("interactor.ac", ac)) .setProjection(Projections.countDistinct("interaction.ac")).uniqueResult(); return count.intValue(); }
public Integer countInteractionsForInteractorWithAc( String ac ) { final Long count = (Long) getSession().createCriteria(Component.class) .createAlias("interactor", "interactor") .createAlias("interaction", "interaction") .add(Restrictions.eq("interactor.ac", ac)) .setProjection(Projections.countDistinct("interaction.ac")).uniqueResult(); return count.intValue(); }
/** * Counts the partners of the provided interactor AC * @param ac The AC to search * @return The number of parntners for the interactor AC * * @since 1.8.0 */ public Integer countPartnersByAc( String ac ) { final Long count = (Long) partnersByAcCriteria(ac) .setProjection(Projections.countDistinct("prot.ac")).uniqueResult(); return count.intValue(); }
/** * Counts the partners of the provided interactor AC * @param ac The AC to search * @return The number of parntners for the interactor AC * * @since 1.8.0 */ public Integer countPartnersByAc( String ac ) { final Long count = (Long) partnersByAcCriteria(ac) .setProjection(Projections.countDistinct("prot.ac")).uniqueResult(); return count.intValue(); }
public Long countVersions(Long codForm) { return (Long) getSession() .createCriteria(FormVersionEntity.class) .createAlias("formEntity", "formEntity") .add(Restrictions.eq("formEntity.cod", codForm)) .setProjection(Projections.countDistinct("cod")) .setMaxResults(1) .uniqueResult(); } }
public Integer countInteractionsForInteractorWithAc( String ac ) { return ( Integer ) getSession().createCriteria( Component.class ) .createAlias( "interactor", "interactor" ) .createAlias( "interaction", "interaction" ) .add( Restrictions.eq( "interactor.ac", ac ) ) .setProjection( Projections.countDistinct( "interaction.ac" ) ).uniqueResult(); }
public Map<String, Integer> countGroupsByValuesLike( String[] values, String[] objClasses, String type, boolean ignoreCase ) { Map<String, Integer> results = new HashMap<String, Integer>(); List<Object[]> critRes = criteriaByValues( values, objClasses, type, ignoreCase ) .setProjection( Projections.projectionList() .add( Projections.countDistinct( "ac" ) ) .add( Projections.groupProperty( "objClass" ) ) ).list(); for ( Object[] res : critRes ) { results.put( ( String ) res[1], ( Integer ) res[0] ); } return results; }