From 5997a37224701334f05afacbcbbd3885633654f8 Mon Sep 17 00:00:00 2001
From: huangjiayang <5265313@qq.com>
Date: 星期三, 23 四月 2025 09:30:32 +0800
Subject: [PATCH] 【UPDATE】修改查询定时任务模糊查询mapper
---
aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml | 2 +-
aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml
index bb5c8a7..7be5135 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/SysJobLogMapper.xml
@@ -24,7 +24,7 @@
<include refid="selectJobLogVo"/>
<where>
<if test="jobName != null and jobName != ''">
- AND job_name like concat('%', #{jobName}, '%')
+ AND job_name like '%' || #{jobName} || '%'
</if>
<if test="jobGroup != null and jobGroup != ''">
AND job_group = #{jobGroup}
diff --git a/aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml b/aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml
index f7d7396..37e1e1b 100644
--- a/aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml
+++ b/aps-modules/aps-job/src/main/resources/mapper/job/SysJobMapper.xml
@@ -29,7 +29,7 @@
<include refid="selectJobVo"/>
<where>
<if test="jobName != null and jobName != ''">
- AND job_name like concat('%', #{jobName}, '%')
+ AND job_name like '%' || #{jobName} || '%'
</if>
<if test="jobGroup != null and jobGroup != ''">
AND job_group = #{jobGroup}
--
Gitblit v1.9.3