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?