Can we select distinct jsonb column in CriteriaBuilder?

Viewed 12

Need to use CriteriaBuilder to select distinct jsonb column. I tried below but not working :

CriteriaBuilder builder = em.getCriteriaBuilder();
CriteriaQuery query = builder.createQuery();
Root<Person> root = query.from(Person.class);

Expression<String> function = builder.function("jsonb_extract_path_text", String.class,
root.<String>get("user"), builder.literal("address"));
query.multiselect(function).distinct(true);

Do you know how I can make such a distinct in my JPA CriteriaQuery?

0 Answers
Related