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; }
@Override public ExportActionableDynamicQuery getExportActionableDynamicQuery( PortletDataContext portletDataContext) { ExportActionableDynamicQuery exportActionableDynamicQuery = _ddmFormInstanceRecordLocalService.getExportActionableDynamicQuery( portletDataContext); final ActionableDynamicQuery.AddCriteriaMethod addCriteriaMethod = exportActionableDynamicQuery.getAddCriteriaMethod(); exportActionableDynamicQuery.setAddCriteriaMethod( dynamicQuery -> { addCriteriaMethod.addCriteria(dynamicQuery); Property formInstanceRecordIdProperty = PropertyFactoryUtil.forName("formInstanceRecordId"); DynamicQuery formInstanceRecordVersionDynamicQuery = getRecordVersionDynamicQuery(); dynamicQuery.add( formInstanceRecordIdProperty.in( formInstanceRecordVersionDynamicQuery)); Property formInstanceIdProperty = PropertyFactoryUtil.forName( "formInstanceId"); DynamicQuery formInstanceDynamicQuery = getFormInstanceDynamicQuery(); dynamicQuery.add( formInstanceIdProperty.in(formInstanceDynamicQuery)); }); return exportActionableDynamicQuery; }
.add(PropertyFactoryUtil.forName("status").eq( WorkflowConstants.STATUS_APPROVED)) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIdsRecursively)) .addOrder(OrderFactoryUtil.desc("priority"))
workflowStatusProperty.in( _journalArticleStagedModelDataHandler. getExportableStatuses()));
.forClass(MBThread.class, PortalClassLoaderUtil.getClassLoader()) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIds)) .add(PropertyFactoryUtil.forName("threadId").notIn(
ProjectionFactoryUtil.property("structureId")); disjunction.add(classPKProperty.in(ddmStructureDynamicQuery));
StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler(JournalFolder.class.getName()); dynamicQuery.add(workflowStatusProperty.in( stagedModelDataHandler.getExportableStatuses()));
StagedModelDataHandler<?> stagedModelDataHandler = StagedModelDataHandlerRegistryUtil.getStagedModelDataHandler(JournalArticle.class.getName()); dynamicQuery.add(workflowStatusProperty.in( stagedModelDataHandler.getExportableStatuses()));