cptwunderlich opened DATAREST-1280 and commented

Collection resources can't be sorted by associated properties.

This is a huge and quite franky not very understandable limitation.

I have prepared an example - link can be found in "Reference URL".

The example uses Articles having a Unit. Querying via JPQL like in the Unit Test works like a charm. Just passing "unit.code" works and since that is the primary key, no join is needed. Adding "unit.fullName" to the query automatically uses a join, without changing the query.

I've also added QueryDsl to the Example, to show how strange it seems, that you can filter by a property, but you can't sort by it.

Where this is really stands out is with Projections/Excerpts. I want to list my Articles and I'd like to sort by Unit. Now I'm including the Unit's abbreviation or code in the Projection and knowing the property name, I can even filter it - but I just can't sort by it.

Digging through the framework, I found JacksonMappingAwareSortTranslator.mapPropertyPath(), which returns if it finds a linkable association, instead of continuing creating the 'sort' property. Why? What's the rationale?

Affects: 3.0.9 (Kay SR9)

Reference URL: https://github.com/cptwunderlich/SpringDataRestMWEs/tree/master/AssociationSort

2 votes, 3 watchers