spring-projects
SortTranslator ignores snake-cased properties [DATAREST-1276]
Édouard Hue opened DATAREST-1276 and commented
Given a @Document annotated class with the following attribute, and an according @RepositoryRestResource:
@Field
@JsonProperty("cooking_duration")
private Duration cookingDuration;
When issuing a GET request with ?sort=cooking_duration, the org.springframework.data.rest.webmvc.json.JacksonMappingAwareSortTranslator won't translate cooking_duration to cookingDuration and no sorting is performed.
When changing @JsonProperty("cooking_duration") to @JsonProperty("cooking-duration"), and doing a ?sort=cooking-duration request, JacksonMappingAwareSortTranslator properly resolves the property name.
It looks like org.springframework.data.rest.webmvc.json.JacksonMappingAwareSortTranslator.SortTranslator#SPLITTER is used to split the property name with _ and .. I can see the case for splitting on . for nested properties paths, but why would you split on underscores?
No further details from DATAREST-1276
Any update on this one? Issue is still there in sdr-3.4.6 https://stackoverflow.com/questions/66829865/spring-data-rest-cannot-sort-by-localdatetime-field
It seems it has been around for a while? https://stackoverflow.com/questions/40746303/spring-data-rest-sorting-fields-with-underscores/40862101#40862101
