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!