You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by xi...@apache.org on 2023/07/11 12:12:23 UTC
[dolphinscheduler] branch dev updated: [Improvement-12700][Project]Improve the sql of listAuthorizedProjects (#12702)
This is an automated email from the ASF dual-hosted git repository.
xincheng pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/dev by this push:
new 29a9888167 [Improvement-12700][Project]Improve the sql of listAuthorizedProjects (#12702)
29a9888167 is described below
commit 29a98881679f9a3f307350f6c579583b66dc9ea0
Author: Rick Cheng <ri...@gmail.com>
AuthorDate: Tue Jul 11 20:12:16 2023 +0800
[Improvement-12700][Project]Improve the sql of listAuthorizedProjects (#12702)
---
.../org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml | 6 ++++++
1 file changed, 6 insertions(+)
diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
index c852ffa284..296a42a5fb 100644
--- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
+++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
@@ -183,6 +183,12 @@
and dp.id in (select project_id from t_ds_relation_project_user where user_id=#{userId}
union select id as project_id from t_ds_project where user_id=#{userId})
</if>
+ <if test="projectsIds != null and projectsIds.size() > 0">
+ and dp.id in
+ <foreach item="id" index="index" collection="projectsIds" open="(" separator="," close=")">
+ #{id}
+ </foreach>
+ </if>
</select>
<select id="queryAllProjectForDependent" resultType="org.apache.dolphinscheduler.dao.entity.Project">