protected void addDefaultCriteria(DynamicQuery dynamicQuery) { if (_companyId > 0) { Property property = PropertyFactoryUtil.forName("companyId"); dynamicQuery.add(property.eq(_companyId)); } if (_groupId > 0) { Property property = PropertyFactoryUtil.forName( _groupIdPropertyName); dynamicQuery.add(property.eq(_groupId)); } }
@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(); }
protected void addOrderCriteria(DynamicQuery dynamicQuery) { if (_addOrderCriteriaMethod == null) { dynamicQuery.addOrder( OrderFactoryUtil.asc(_primaryKeyPropertyName)); } else { _addOrderCriteriaMethod.addOrderCriteria(dynamicQuery); } }
@Override public <V> List<V> findWithDynamicQuery( DynamicQuery dynamicQuery, int start, int end) { Session session = null; try { session = openSession(); dynamicQuery.setLimit(start, end); dynamicQuery.compile(session); return dynamicQuery.list(); } catch (Exception e) { throw processException(e); } finally { closeSession(session); } }
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; }
.forClass(MBThread.class, PortalClassLoaderUtil.getClassLoader()) .add(PropertyFactoryUtil.forName("groupId").eq(scopeGroupId)) .add(PropertyFactoryUtil.forName("status").eq( WorkflowConstants.STATUS_APPROVED)) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIdsRecursively)) .addOrder(OrderFactoryUtil.desc("priority")) .addOrder(OrderFactoryUtil.desc("lastPostDate"));
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; }
private void _transformRatingsData( final String classPKFieldName, final long classPKFieldValue, final String className, RatingsType fromRatingsType, RatingsType toRatingsType) throws PortalException { if ((toRatingsType == null) || fromRatingsType.equals(toRatingsType)) { return; } RatingsDataTransformer ratingsDataTransformer = _serviceTracker.getService(); ActionableDynamicQuery.PerformActionMethod<RatingsEntry> performActionMethod = ratingsDataTransformer.transformRatingsData( fromRatingsType, toRatingsType); if (performActionMethod == null) { return; } ActionableDynamicQuery ratingsEntryActionableDynamicQuery = RatingsEntryLocalServiceUtil.getActionableDynamicQuery(); ratingsEntryActionableDynamicQuery.setAddCriteriaMethod( dynamicQuery -> { Property property = PropertyFactoryUtil.forName( classPKFieldName); dynamicQuery.add(property.eq(classPKFieldValue)); property = PropertyFactoryUtil.forName("className"); dynamicQuery.add(property.eq(className)); }); ratingsEntryActionableDynamicQuery.setPerformActionMethod( performActionMethod); ratingsEntryActionableDynamicQuery.performActions(); }
.forClass(MBThreadFlag.class, PortalClassLoaderUtil.getClassLoader()) .setProjection(ProjectionFactoryUtil.property("threadId")) .add(PropertyFactoryUtil.forName("userId") .eq(currentUserId)); .forClass(MBThread.class, PortalClassLoaderUtil.getClassLoader()) .add(PropertyFactoryUtil.forName("categoryId").in( categoryIds)) .add(PropertyFactoryUtil.forName("threadId").notIn( readThreadIds)) .add(PropertyFactoryUtil.forName("status").eq( WorkflowConstants.STATUS_APPROVED));
public static void addOrderByComparator( DynamicQuery dynamicQuery, OrderByComparator<?> obc) { if (obc == null) { return; } String[] orderByFields = obc.getOrderByFields(); for (String orderByField : orderByFields) { if (obc.isAscending(orderByField)) { dynamicQuery.addOrder(asc(orderByField)); } else { dynamicQuery.addOrder(desc(orderByField)); } } }
@Override public void verifyPolicy() throws PortalException { ActionableDynamicQuery groupActionableDynamicQuery = GroupLocalServiceUtil.getActionableDynamicQuery(); groupActionableDynamicQuery.setAddCriteriaMethod( dynamicQuery -> { Property property = PropertyFactoryUtil.forName("site"); dynamicQuery.add(property.eq(true)); }); groupActionableDynamicQuery.setPerformActionMethod( (Group group) -> { verifyPolicy(group); ActionableDynamicQuery userGroupRoleActionableDynamicQuery = UserGroupRoleLocalServiceUtil.getActionableDynamicQuery(); userGroupRoleActionableDynamicQuery.setGroupId( group.getGroupId()); userGroupRoleActionableDynamicQuery.setPerformActionMethod( (UserGroupRole userGroupRole) -> { verifyPolicy(userGroupRole.getRole()); }); userGroupRoleActionableDynamicQuery.performActions(); }); groupActionableDynamicQuery.performActions(); }
clazz.getClassLoader()); versionArticleDynamicQuery.setProjection( ProjectionFactoryUtil.alias( ProjectionFactoryUtil.max("versionArticle.version"), versionArticleDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "this.resourcePrimKey", "status"); versionArticleDynamicQuery.add( workflowStatusProperty.in( _journalArticleStagedModelDataHandler. "version"); dynamicQuery.add( versionProperty.eq(versionArticleDynamicQuery)); });
/** * @see #isWithinDateRange(Date) */ @Override public void addDateRangeCriteria( DynamicQuery dynamicQuery, String propertyName) { Criterion criterion = getDateRangeCriteria(propertyName); if (criterion == null) { return; } dynamicQuery.add(criterion); }
DDMStructure.class); dynamicQuery.add( classNameIdProperty.eq(ddmStructureClassNameId)); JournalArticle.class); ddmStructureDynamicQuery.add( classNameIdProperty.eq(articleClassNameId)); ddmStructureDynamicQuery.setProjection( ProjectionFactoryUtil.property("structureId")); dynamicQuery.add(disjunction); });
protected void addCreateDateProperty( PortletDataContext portletDataContext, DynamicQuery dynamicQuery) { if (!portletDataContext.hasDateRange()) { return; } Property createDateProperty = PropertyFactoryUtil.forName("createDate"); Date startDate = portletDataContext.getStartDate(); dynamicQuery.add(createDateProperty.ge(startDate)); Date endDate = portletDataContext.getEndDate(); dynamicQuery.add(createDateProperty.le(endDate)); }
clazz.getClassLoader()); journalArticleDynamicQuery.setProjection( ProjectionFactoryUtil.property("resourcePrimKey")); journalArticleDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "journalArticle.resourcePrimKey", "this.resourcePrimKey")); journalArticleDynamicQuery.add( RestrictionsFactoryUtil.eqProperty( "journalArticle.groupId", "this.groupId")); "DDMStructureKey"); journalArticleDynamicQuery.add( ddmStructureKey.in(ddmStructureKeys)); }; journalArticleDynamicQuery.add( statusProperty.in(statuses)); dynamicQuery.add( resourcePrimKeyProperty.in(journalArticleDynamicQuery)); });
protected void addCreateDateProperty( PortletDataContext portletDataContext, DynamicQuery dynamicQuery) { if (!portletDataContext.hasDateRange()) { return; } Property createDateProperty = PropertyFactoryUtil.forName("createDate"); Date startDate = portletDataContext.getStartDate(); dynamicQuery.add(createDateProperty.ge(startDate)); Date endDate = portletDataContext.getEndDate(); dynamicQuery.add(createDateProperty.le(endDate)); }
ddmFormInstanceRecordVersionLocalService.dynamicQuery(); ddmFormInstanceRecordVersionDynamicQuery.setProjection( ProjectionFactoryUtil.property("formInstanceRecordId")); dynamicQuery.add( ddmFormInstanceRecordIdProperty.in( ddmFormInstanceRecordVersionDynamicQuery)); ddmFormInstanceLocalService.dynamicQuery(); ddmFormInstanceDynamicQuery.setProjection( ProjectionFactoryUtil.property("formInstanceId")); dynamicQuery.add( ddmFormInstanceProperty.in(ddmFormInstanceDynamicQuery)); });