How to search in Json Hash-Map with JPQL by key or value

210 views Asked by At

my entity code

Is there a way i can search in the json map by a JPQL query ?

I tried with Blaze-Persistence API but when i write :

@EntityGraph(value = "record")
@Query(value = "SELECT r from Records r WHERE JSON_GET(r.data , '123') = :value")
List<Record> findAllByViewAndColumn(String value);

JSON_GET is not recognizable. I referenced to JPQL how to search on JSON Map by KEY name or VALUE , but its not working for me ...

0

There are 0 answers