Spring Boot REST: Sort direction is ignored, but Sort generally works

Viewed 2146

I am writing an REST API with Spring Boot. Therefore I get employees by Name. I am passing the Pageable parameter for sorting, the problem is the direction is ignored. So Spring always sorts asc nerve desc, which is the default behavior. I have no idea what I am doing wrong.

I need to add, that sorting in general is working, because if I don't pass the chrValue as sort parameter, I get items like they are stored in the DB.

The Request:

http://localhost:8080/dimensionAttributeValues/search/findDimensionAttributeValueByDimensionAttributeDimensionAttributeID?dimensionAttributeId=1&page=0&size=1&sort=chrValue&chrValue.dir=desc

The Repository:

@RepositoryRestResource(collectionResourceRel = "dimensionAttributeValue", path = "dimensionAttributeValues")
@CrossOrigin(exposedHeaders="Access-Control-Allow-Origin")
public interface DimensionAttributeValueRepository extends PagingAndSortingRepository<DimensionAttributeValue, Long> {
    Page<DimensionAttributeValue> findDimensionAttributeValueByDimensionAttributeDimensionAttributeID(@Param(value = "dimensionAttributeId") long dimensionAttributeId, Pageable pageable);
    Page<DimensionAttributeValue> findDimensionAttributeValueByMasterDataMasterDataIDAndDimensionAttributeDimensionAttributeID(@Param(value = "masterDataId") long masterDataId, @Param(value = "dimensionAttributeId") long dimensionAttributeId, Pageable pageable);
    Page<DimensionAttributeValue> findDimensionAttributeValueByDimensionAttributeDimensionDimensionIDOrDimensionAttributeDimensionAttributeIDOrderByChrValue(@Param(value="dimensionID") long dimensionID, @Param(value = "dimensionAttributeID") long dimensionAttributeID, Pageable pageable);
    Page<DimensionAttributeValue> findAllByDimensionAttributeDimensionAttributeIDAndChrValueStartingWith(@Param(value = "dimensionAttributeId") long dimensionID, @Param(value = "chrValue") String chrValue, Pageable pageable);

}

The Entity:

@Entity
@Table(name = "DimensionAttributeValue")
public class DimensionAttributeValue {

    @Id
    @GeneratedValue
    @Column(name = "DimensionAttributeValue_ID")
    private long dimensionAttributeValueID;

    @ManyToOne
    @JoinColumn(name = "DimensionAttribute_ID")
    private DimensionAttribute dimensionAttribute;

    @ManyToOne
    @JoinColumn(name = "MasterData_ID")
    private MasterData masterData;

    @Column (name = "ChrValue")
    private String chrValue;

    @Column (name = "IntValue")
    private Long intValue;

    @Column (name = "DecValue")
    private Double decValue;

    @Column (name = "DatValue")
    private String datValue;

    @Column (name = "BlnValue")
    private Boolean blnValue;

    @ManyToOne
    @JoinColumn (name = "LnkValue")
    private DimensionAttributeValue lnkValue;

    @ManyToOne
    @JoinColumn (name = "LstValue")
    private DimensionAttributeList lstValue;

    @Column (name = "StartDate")
    private Date startDate;

    // [...]
}

Any ideas? Thanks!

1 Answers

Try this URL .

http://localhost:8080/dimensionAttributeValues/search/findDimensionAttributeValueByDimensionAttributeDimensionAttributeID?dimensionAttributeId=1&page=0&size=1&sort=chrValue,desc.

This will sort your data in descending Order.

Related