1

I have this class:

class School {
 private Map<String, Object> questionnaire;

}
...

Questionnaire is stored in my db as a VARCHAR(MAX) json and I would like to query it like this:

select sch from School where sch.questionnaire['5'] like '%02.%'

Which of course does not work. How to query through Map in HQL ? If possible with out using JSON_QUERY.

0 Answers0