spring中的%like%查询JpaRepositoryn[重复]

Question

我想在JpaRepository中编写一个like查询，但它没有返回任何东西。

下面是我的代码：

@Query(value = "select * from DC_NOTIF_EVNT_ORG_CONFIG C JOIN DC_NOTIF_EVNT_ORG_PERS B ON 

    B.NOTIF_EVNT_ORG_CONFIG_ID=C.NOTIF_EVNT_ORG_CONFIG_ID JOIN GRR_PARTY GRR ON GRR.PERS_ID =B.PERS_ID JOIN DC_NOTIF_EVNT_CONFIG D ON C.NOTIF_EVNT_CONFIG_ID=D.NOTIF_EVNT_CONFIG_ID JOIN DC_SCHED_FREQ_CONFIG E ON E.SCHED_FREQ_CONFIG_ID= C.SCHED_FREQ_CONFIG_ID JOIN DC_NOTIF_EVNT_SCHED F ON F.NOTIF_EVNT_SCHED_ID=C.NOTIF_EVNT_SCHED_ID JOIN DC_ORG G ON C.ORG_ID=G.ORG_ID WHERE C.ORG_ID=:orgId AND GRR.PERS_ID=:persId  AND C.ACT_IND=1 AND STRT_DT LIKE TO_DATE(TO_CHAR(TO_DATE(:%strtDt%,'YYYY-MM-DD'),'MM/DD/YYYY'),'MM/DD/YYYY') AND ROWNUM<2",nativeQuery = true)

    List<Notlist> ifNotificationExist(@Param("orgId") Long orgId, @Param("persId") Long persId,@Param("strtDt") LocalDate strtDt);

Answer 1

请尝试：

 /* as before ...*/
to_char(STRT_DT, 'YYYY-MM-DD') LIKE '%'||to_char(:strtDt, 'YYYY-MM-DD')||'%' 
/*...*/

...我甚至认为：

to_char(STRT_DT, 'YYYY-MM-DD') = to_char(:strtDt, 'YYYY-MM-DD')

..会很好的！

sql prettyprint-override">... STRT_DT LIKE TO_DATE(TO_CHAR(TO_DATE(:%strtDt%,'YYYY-MM-DD'),'MM/DD/YYYY'),'MM/DD/YYYY') ...

null