From 4e8da8055692c845345f48e891850b6a685977be Mon Sep 17 00:00:00 2001
From: liujie <1793218484@qq.com>
Date: 星期四, 25 六月 2026 15:43:51 +0800
Subject: [PATCH] update
---
admin-server/src/main/java/com/estate/expert/admin/domain/standard/problem/ProblemRepository.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/admin-server/src/main/java/com/estate/expert/admin/domain/standard/problem/ProblemRepository.java b/admin-server/src/main/java/com/estate/expert/admin/domain/standard/problem/ProblemRepository.java
index 7bfd141..76e1883 100644
--- a/admin-server/src/main/java/com/estate/expert/admin/domain/standard/problem/ProblemRepository.java
+++ b/admin-server/src/main/java/com/estate/expert/admin/domain/standard/problem/ProblemRepository.java
@@ -12,7 +12,9 @@
@Query("select p from Problem p where p.hierarchyId = :hierarchyId " +
"and p.hierarchyPath in :hierarchyPaths " +
- "and (:keyword is null or :keyword = '' or p.description like %:keyword% ) " +
+ "and (:keyword is null or :keyword = '' " +
+ "or p.description like %:keyword% " +
+ "or function('json_search', p.specificTerms, 'one', concat(concat('%', :keyword), '%')) is not null) " +
"and p.deleted = false")
Page<Problem> findProblems(@Param("hierarchyId") Integer hierarchyId,
@Param("hierarchyPaths") List<String> hierarchyPaths,
--
Gitblit v1.7.1