Spring Data REST - How to sort an entity by JSON ignored field?

Question

I am using Spring Data REST and I have the following entity in my project.

@Data
@Entity
public class Loan{

    @Id
    @GeneratedValue
    private Long id;

    @JsonIgnore
    private Long createdDate;

    private Long amount;

    private Long repaymentStartDate;

}

Now I want to sort the loans by the createdDate which will be automatically filled and JSONIgnored to prevent it from being updated. But I am unable to sort the loans by the createdDate when I call the endpoint loans?sort=createdDate.

How do I fix this?

Here is my repository:

public interface LoanRepository extends PagingAndSortingRepository<Loan, Long>{

}

How does the restcontroller looks like? Please add the code to you question. — Diego Krupitza
– Diego Krupitza, Commented Feb 18, 2018 at 16:42
Since I am using Spring Data REST there is no need to write separate controller. Spring will generate it when I extend the repository interface. — Charlie
– Charlie, Commented Feb 18, 2018 at 16:48
When the field is annotated with ‘@JsonIgnore’ the field is not visible for the user. So it is clear that it is not possible to sort the result by something the user cannot see. — Diego Krupitza
– Diego Krupitza, Commented Feb 18, 2018 at 17:02

Cepr0 · Accepted Answer · 2018-03-28 21:11:47Z

3

To workaround try to replace @JsonIgnore to @JsonProperty(access = READ_ONLY). It prevents createdDate from changing but remains it in the json body.

UPDATED

For Spring Boot 1.5.10+ instead of @JsonProperty(access = READ_ONLY) you can use @JsonIgnoreProperties("createdDate") on top of the entity.

edited Mar 28, 2018 at 21:11

answered Feb 18, 2018 at 17:58

Cepr0

31.1k9 gold badges82 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Spring Data REST - How to sort an entity by JSON ignored field?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related