I've also tried something like .distinctBy { Production } but here only one row is returned.

# exposed

[danielm]

I've also tried something like .distinctBy { Production } but here only one row is returned.

[Tristan Caron]

distincBy is a function provided by kotlin.Collection, not exposed. You tried what I answer you before?

[danielm]

Still trying to wrap my head around it

[Tristan Caron]

How would you write it using raw SQL?

[danielm]

Hmm, I was not able to figure out an appropriate SQL statement

[danielm]

But your hit about collections helped a lot, thanks.

[danielm]

Just for the records I'm using now:

[danielm]

...
.orderBy(Performance.date)
.map { it[Production.name] }
.distinct()
.forEach {
  println(it)
}