Spring data JPA fails to sort with JSONB column

[abirami-els]

I'm using Spring Data JPA (v3.0.10) to sort and paginate a table in Postgres.

I'm facing issue when I try to sort by JSONB column.

Pageable p = PageRequest.of(1,19, JpaSort.unsafe(Sort.Direction.ASC, "publicationSchedule->>'permissionDeadline'"));

Exception:

Request processing failed: org.springframework.data.mapping.PropertyReferenceException: No property 'publicationSchedule->>'permissionDeadline'' found for type 'Publication'] with root cause
org.springframework.data.mapping.PropertyReferenceException: No property 'publicationSchedule->>'permissionDeadline'' found for type 'Publication'
	at org.springframework.data.mapping.PropertyPath.<init>(PropertyPath.java:90) ~[spring-data-commons-3.2.4.jar:3.2.4]

[christophstrobl]

duplicate of: #1997

[abirami-els]

Is this still an open issue?

[mp911de]

It is and it will be handled through the referenced ticket.