/** * A distinct property value count projection * * @param propertyName The name of the property to count over * * @return The count projection * * @see CountProjection */ public static CountProjection countDistinct(String propertyName) { return new CountProjection( propertyName ).setDistinct(); }
@Override protected List buildFunctionParameterList(Criteria criteria, CriteriaQuery criteriaQuery) { final String[] cols = criteriaQuery.getColumns( propertyName, criteria ); return ( distinct ? buildCountDistinctParameterList( cols ) : Arrays.asList( cols ) ); }
/** * A property value count projection * * @param propertyName The name of the property to count over * * @return The count projection * * @see CountProjection */ public static CountProjection count(String propertyName) { return new CountProjection( propertyName ); }
s.clear(); count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "nickName" ).setDistinct() ) .uniqueResult(); assertEquals( 2, count.longValue() ); try { count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "name" ).setDistinct() ) .uniqueResult(); if ( ! getDialect().supportsTupleDistinctCounts() ) { s.clear(); count = ( Long ) s.createCriteria( Human.class ) .setProjection( Projections.count( "name.first" ).setDistinct() ) .uniqueResult(); assertEquals( 1, count.longValue() );
@SuppressWarnings("unchecked") static public List<Object[]> findMaxObject() throws HibernateException { Session s = null; try { s = openSession(); //Query q = s.createQuery("select count(ae.subject), ae.subject FROM "+ AE_CLASS + " AS ae "+ //"GROUP BY ae.subject ORDER BY count(ae.subject) desc"); Criteria crit = s.createCriteria(AuditEvent.class); crit.setProjection(Projections.projectionList() .add(Projections.count("object").as("gcount")) .add(Projections.groupProperty("object")) ); crit.addOrder(Order.desc("gcount")); crit.setMaxResults(10); return crit.list(); } finally { close(s); } } }
/** * A property value count */ public static CountProjection count(String propertyName) { return new CountProjection(propertyName); }
private List<Event> retrieveGrouped(List<String> eventActions, User user, Date startTime, Date stopTime, Set<Integer> appIds, Set<Integer> teamIds, Set<Integer> vulnIds, Set<Integer> defectIds) { Criteria criteria = getEventCriteria(eventActions, user, startTime, stopTime, appIds, teamIds, vulnIds, defectIds); criteria.setProjection(Projections.projectionList() .add(Projections.count("id").as("groupCount")) .add(Projections.groupProperty("eventAction").as("eventAction")) .add(Projections.groupProperty("scan").as("scan")) .add(Projections.groupProperty("deletedScanId").as("deletedScanId")) .add(Projections.min("date"), "date") .add(Projections.groupProperty("application"), "application") .add(Projections.groupProperty("user"), "user") ); criteria.setResultTransformer(Transformers.aliasToBean(Event.class)); List<Event> events = criteria.list(); for (Event event : events) { EventAction eventAction = event.getEventActionEnum(); EventAction groupedEventAction = eventAction.getGroupedEventAction(); String groupedEventActionString = groupedEventAction.name(); event.setEventAction(groupedEventActionString); } return events; }
/** * A distinct property value count */ public static CountProjection countDistinct(String propertyName) { return new CountProjection(propertyName).setDistinct(); }
/** * A property value count */ public static CountProjection count(String propertyName) { return new CountProjection(propertyName); }
protected List buildFunctionParameterList(Criteria criteria, CriteriaQuery criteriaQuery) { String cols[] = criteriaQuery.getColumns( propertyName, criteria ); return ( distinct ? buildCountDistinctParameterList( cols ) : Arrays.asList( cols ) ); }
/** * A distinct property value count */ public static CountProjection countDistinct(String propertyName) { return new CountProjection(propertyName).setDistinct(); }
/** * A property value count */ public static CountProjection count(String propertyName) { return new CountProjection(propertyName); }
protected List buildFunctionParameterList(Criteria criteria, CriteriaQuery criteriaQuery) { String cols[] = criteriaQuery.getColumns( propertyName, criteria ); return ( distinct ? buildCountDistinctParameterList( cols ) : Arrays.asList( cols ) ); }
/** * A distinct property value count */ public static CountProjection countDistinct(String propertyName) { return new CountProjection(propertyName).setDistinct(); }
/** * A property value count */ public static CountProjection count(String propertyName) { return new CountProjection(propertyName); }
/** * A distinct property value count */ public static CountProjection countDistinct(String propertyName) { return new CountProjection(propertyName).setDistinct(); }
public final class Projections { public static CountProjection countDistinct(String propertyName) { return new CountProjection(propertyName).setDistinct(); }