[GitHub] [incubator-streampark] 1996fanrui commented on a diff in pull request #2262: [Feature][Issue-2214] Team add number, can direct select.

[GitBox <gi...@apache.org>]

1996fanrui commented on code in PR #2262:
URL: https://github.com/apache/incubator-streampark/pull/2262#discussion_r1082857197


##########
streampark-console/streampark-console-service/src/main/resources/mapper/system/MemberMapper.xml:
##########
@@ -68,4 +68,15 @@
         </if>
     </select>
 
+    <select id="findUsersNotInTeam" resultType="org.apache.streampark.console.system.entity.User">
+        select tu.* from t_user tu
+        where (tu.user_id, tu.username)
+        not in (
+                    select u.user_id, u.username
+                        from t_user u join t_member m
+                        on m.team_id = #{teamId}
+                        and m.user_id = u.user_id
+                )
+    </select>

Review Comment:
   Can the `username` be removed?



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@streampark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org