List of alterCountProjection() Examples

Examples of alterCountProjection()

org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterCountProjection()

Sometimes the altered projection ( {@link #alterProjection(String)}) might cause the result set to have different number of results than the default/unaltered projection. Leaving the count query in the default form could then generate seemingly inconsistent results, where the data query and the count query wouldn't match up.

An example of a projection that might alter the number of results is the {@code " distinct ..."} projection thatwould only return distinct results from a dataset, while the default count query (COUNT(*)) would produce the count including duplicate results that were eliminated in the returned data.

In these cases one can also alter the count query to count the results the data query will return. @param countProjection a complete JPQL fragment expressing the count expression (e.g.{@code COUNT(DISTINCT ...)})

            // the altered projection using DISTINCT), of which this is the only one in the code base,
            // and we are in control of the order by clause, and therefore are predictably working with
            // the JPQL above, I've chosen to just make a change to the custom altered projection, using
            // the JPQL to guide me.
            generator.alterProjection(" distinct orderingField0");
            generator.alterCountProjection(" count(distinct orderingField0)");
            CriteriaQueryRunner<MeasurementDefinition> queryRunner = new CriteriaQueryRunner(criteria, generator,
                entityManager);
            definitions = queryRunner.execute();


            // Reset paging -- remove ordering, add group by.

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

Examples of alterCountProjection()

Examples of org.rhq.enterprise.server.util.CriteriaQueryGenerator.alterCountProjection()