From 227ea5a006d52edce7010cd9b950ee4d5d783ea8 Mon Sep 17 00:00:00 2001 From: 龚焕茏 <2842157468@qq.com> Date: 星期四, 11 七月 2024 15:56:42 +0800 Subject: [PATCH] fix:排除标签bug修复 --- src/main/resources/mapper/ExamPaperMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/src/main/resources/mapper/ExamPaperMapper.xml b/src/main/resources/mapper/ExamPaperMapper.xml index 5783189..514994d 100644 --- a/src/main/resources/mapper/ExamPaperMapper.xml +++ b/src/main/resources/mapper/ExamPaperMapper.xml @@ -488,7 +488,7 @@ <if test="excludeTagIds != null and excludeTagIds.size > 0"> <if test="tagIds != null and tagIds.size > 0">and</if> <foreach collection="excludeTagIds" open="(" separator="and" close=")" item="item"> - NOT find_in_set(#{item}, group_concat(b.tag_id) OR group_concat(b.tag_id) IS NULL) + (NOT find_in_set(#{item}, group_concat(b.tag_id)) OR group_concat(b.tag_id) IS NULL) </foreach> </if> order by a.id -- Gitblit v1.8.0