How to Use sorting in Spring Data Rest GET method

Question

When I create any repository in spring framework like following it gives method by default to get all records of the entity using this API

GET : http://localhost:3000/api/addresses

It sends data from ascending order But If I want my data in descending order than How can I specify this ?

Address Repository

    public interface AddressRepository extends JpaRepository<Address, Long> 

    {
    }

If it is findAll, then you can override this and add a condition for order by in your query — CrazyMac
– CrazyMac, Commented Jun 22, 2017 at 6:14
@CrazyMac My Query ? NO :| I didn't write any Query it is Spring default call to get records — SFAH
– SFAH, Commented Jun 22, 2017 at 6:16
What is your front end. Are you using Angular ? If yes, then you can use orderBy : 'name' as an approach to sort — CrazyMac
– CrazyMac, Commented Jun 22, 2017 at 7:06

The Hungry Dictator · Accepted Answer · 2017-06-30 05:14:56Z

7

Perhaps,you can :

localhost:3000/api/addresses?sort={property},desc

this will help you sort by property desc

edited Jun 30, 2017 at 5:14

The Hungry Dictator

3,4845 gold badges41 silver badges56 bronze badges

answered Jun 28, 2017 at 2:45

ChenAn

1361 silver badge2 bronze badges

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

1 Comment

ChenAn Over a year ago

it will work for you.localhost:3000/api/addresses?sort=id,desc that will sorted by the property of id desc

webdizz · Accepted Answer · 2017-06-22 06:27:00Z

4

You can also specify this as part of your request, take a look at documentation here Sorting.

Also please take a look at similar answer here.

answered Jun 22, 2017 at 6:27

webdizz

8467 silver badges10 bronze badges

Comments

stzoannos · Accepted Answer · 2017-06-22 06:15:34Z

0

Try inside the AddressRepository class something like:

public List<Address> findAllByOrderByIdDesc();

of course you can change the "ById" part with any other field you want to use for sorting.

answered Jun 22, 2017 at 6:15

stzoannos

9384 silver badges10 bronze badges

1 Comment

SFAH Over a year ago

I know all these methods :\ I don't want to write any method just wants to modify GET : localhost:3000/api/addresses this query so that get records in desc order

Collectives™ on Stack Overflow

How to Use sorting in Spring Data Rest GET method

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related