| | |
|---|
| | | |
|---|
| | | @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, |
|---|
