public static Projection sqlGroupProjection( String sql, String groupBy, String[] columnAliases, Type[] types) { return getProjectionFactory().sqlGroupProjection( sql, groupBy, columnAliases, types); }
protected Projection getCountProjection() { return ProjectionFactoryUtil.rowCount(); }
protected DynamicQuery getFormInstanceDynamicQuery() { StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler( DDMFormInstanceRecord.class.getName()); Class<?> clazz = stagedModelDataHandler.getClass(); DynamicQuery formInstanceDynamicQuery = DynamicQueryFactoryUtil.forClass( DDMFormInstance.class, "formInstance", clazz.getClassLoader()); formInstanceDynamicQuery.setProjection( ProjectionFactoryUtil.property("formInstanceId")); formInstanceDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "formInstance.formInstanceId", "formInstanceId")); return formInstanceDynamicQuery; }
@Override protected Projection getCountProjection() { return ProjectionFactoryUtil.countDistinct( "resourcePrimKey"); } };
protected DynamicQuery getRecordVersionDynamicQuery() { StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler( DDMFormInstanceRecord.class.getName()); Class<?> clazz = stagedModelDataHandler.getClass(); DynamicQuery formInstanceRecordVersionDynamicQuery = DynamicQueryFactoryUtil.forClass( DDMFormInstanceRecordVersion.class, "formInstanceRecordVersion", clazz.getClassLoader()); formInstanceRecordVersionDynamicQuery.setProjection( ProjectionFactoryUtil.property("formInstanceRecordId")); Property statusProperty = PropertyFactoryUtil.forName("status"); formInstanceRecordVersionDynamicQuery.add( statusProperty.in(stagedModelDataHandler.getExportableStatuses())); formInstanceRecordVersionDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "formInstanceRecordVersion.version", "version")); formInstanceRecordVersionDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "formInstanceRecordVersion.formInstanceRecordId", "formInstanceRecordId")); return formInstanceRecordVersionDynamicQuery; }
public static Projection alias(Projection projection, String alias) { return getProjectionFactory().alias(projection, alias); }
.forClass(MBThreadFlag.class, PortalClassLoaderUtil.getClassLoader()) .setProjection(ProjectionFactoryUtil.property("threadId")) .add(PropertyFactoryUtil.forName("userId") .eq(currentUserId));
@Override public long countWithDynamicQuery(DynamicQuery dynamicQuery) { return countWithDynamicQuery( dynamicQuery, ProjectionFactoryUtil.rowCount()); }
public static Projection sqlProjection( String sql, String[] columnAliases, Type[] types) { return getProjectionFactory().sqlProjection(sql, columnAliases, types); }
ProjectionFactoryUtil.property("resourcePrimKey"));
@Override public long countWithDynamicQuery( DynamicQuery dynamicQuery, Projection projection) { if (projection == null) { projection = ProjectionFactoryUtil.rowCount(); } dynamicQuery.setProjection(projection); List<Long> results = findWithDynamicQuery(dynamicQuery); if (results.isEmpty()) { return 0; } Long firstResult = results.get(0); return firstResult.longValue(); }
public static Projection rowCount() { return getProjectionFactory().rowCount(); }
ProjectionFactoryUtil.property("structureId"));
public static Projection sum(String propertyName) { return getProjectionFactory().sum(propertyName); }
public static Projection avg(String propertyName) { return getProjectionFactory().avg(propertyName); }
public static Projection groupProperty(String propertyName) { return getProjectionFactory().groupProperty(propertyName); }
public static Projection property(String propertyName) { return getProjectionFactory().property(propertyName); }
public static Projection count(String propertyName) { return getProjectionFactory().count(propertyName); }