how to get relation ordered ? for this relation: ...

# room

[calidion]

how to get relation ordered ? for this relation:

data class ExamWithDates(
    @Embedded val exam: Exam,
    @Relation(
        parentColumn = "id",
        entityColumn = "id",
        associateBy = Junction(
            value = ExamDate::class,
            parentColumn = "examId",
            entityColumn = "dateId",
        )
    )
    val dates: List<Date>
)

I need dates ordered by date

[danysantiago]

For filtering and ordering it is best if you use a multimap return type

[danysantiago]

@Query("...")
fun getExams(): Map<Exam, List<Date>>

[danysantiago]

see https://developer.android.com/training/data-storage/room/accessing-data#multimap

[calidion]

ok. i will try it later.