[dolphinscheduler] branch dev updated: [Improvement-12700][Project]Improve the sql of listAuthorizedProjects (#12702)

[xincheng]

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 <rickche...@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">