Skip to content

Allow function calls in Sort / Pageable objects in custom queries. #2273

@pelletier197

Description

@pelletier197

Hello!

Is there a recommended way to sort on computed fields? For instance, in my application, I want to sort by ignoring the diacritics (é, è, à, etc..). To do so, I use apoc.text.clean(department.name) with a custom query and a Pageable. This used to work in spring-data-neo4j 5, but doesn't work anymore.

: Cannot handle order property `apoc.text.clean(department.name)`, it must be a simple property or one-hop path.

The pageable I use is the following..

PageRequest.of(0, 10, Sort.by("apoc.text.clean(department.name)"))

Thank you!

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions