Is it possible to write JPQL to search over embedded Map? For example we have Article entity having Map<String, String> ‘data’ which is converted to JSON using @Converter. This means no additional table is created, only additional column to store JSON. Now I have to write a query which will filter…

If the underlying column type is a JSON-like DDL type, then the JPQL functions key and value won’t work, as these functions only work if you map to tables. You will have to use the proprietary JSON functions of your DBMS( MySQL :: MySQL 8.0 Reference Manual :: 12.18.3 Functions That Search JSON Value…

JPQL on embedded Map

Hibernate ORM

Christian_Thiel May 22, 2023, 11:10am 8

@beikov Thanks for the quick reply. I created this topic.

Topic		Replies	Views
Search in embedded Map stored as Jsonb Hibernate ORM	1	514	May 22, 2023
Search on a jpaquery Hibernate Search	1	321	February 2, 2023
Hibernate Search With JPQL Hibernate Search	3	372	August 31, 2023
How to index Json Column Hibernate Search	4	414	February 8, 2024
How do I use FieldBridge in hibernate-search 6? Hibernate Search	2	797	February 28, 2022

JPQL on embedded Map

Related topics