search

zhangzhenhuajack / spring-data-jpa-guide

spring-data-jpa-guide，Spring Data JPA实战，SpringDataJpa详解
http://www.jackzhang.cn/spring-data-jpa-guide/
363 stars 157 forks source link

Spring Data JPA动态查询的例子 #60

Open zhangzhenhuajack opened 3 months ago

zhangzhenhuajack commented 3 months ago 
    @Query(value = "select w From WorkflowInfo w where w.deleted = false " +
            "and (:#{#param.projectId} is null or w.projectId = :#{#param.projectId}) " +
            "and (:#{#param.projectIds[0]} = -1L or w.projectId in :#{#param.projectIds}) " +
            "and (:#{#param.workflowTemplateInfoIds[0]} = -1L or w.workflowTemplateInfoId in :#{#param.workflowTemplateInfoIds}) " +
            "and (:#{#param.createdBy} is null or w.createdBy = :#{#param.createdBy}) " +
            "and (:#{#param.status} is null or w.status = :#{#param.status})" +
            "and (:#{#param.ownerUserId} is null or w.ownerUserId = :#{#param.ownerUserId})" +
            "and (:#{#param.workflowName} is null or w.workflowName like %:#{#param.workflowName}%)")
    Page<WorkflowInfo> findWorkflowInfoAll(@Param("param") WorkflowInfo param, Pageable pageable);