How to sort by object's field which is inside object?

Question

I have class RoomToday with some field. Inside this class there is a object of Room. I have no field name in RoomToday class.

class RoomToday {
    Room room;
    //other fields
}

class Room {
    String name;
    //
}

And i have repository RoomTodayrepository. Can i have method which sort by Room's name?

Something like that. This request must be in JPA repository:

List<RoomToday> findByIdInOrderByRoomNameAsc(Collection<UUID> id);

Does this answer your question? [Sort ArrayList of custom Objects by property](https://stackoverflow.com/questions/2784514/sort-arraylist-of-custom-objects-by-property) — Nitin Bisht, Apr 22 '20 at 09:33
@NitinBisht I think he wants `JPA` to give him an already by a specific field sorted list — CodeMatrix, Apr 22 '20 at 09:37
i don't think so. i want to sort it in jparepository on database request lvl if it is real — Krazim00da, Apr 22 '20 at 09:37

score 2 · Accepted Answer · answered Apr 22 '20 at 10:29

2

You need to make Room as @Embeddable,

class RoomToday {
    @Embedded
    Room room;
    //other fields
}
@Embeddable
class Room {
    String name;
    //
}

Then create a method in repository as below,

List<RoomToday> findByIdInOrderByRoomNameAsc(Collection<UUID> id);

answered Apr 22 '20 at 10:29

Vikas

1 Answers1