Channels
#exposed
Title
d
danielm
05/31/2018, 2:09 PMI've also tried something like .distinctBy { Production } but here only one row is returned.
t
Tristan Caron
05/31/2018, 2:26 PMdistincBy is a function provided by
kotlin.Collectionexposedd
danielm
05/31/2018, 2:59 PMStill trying to wrap my head around it
t
Tristan Caron
05/31/2018, 3:02 PMHow would you write it using raw SQL?
d
danielm
06/01/2018, 4:12 AMHmm, I was not able to figure out an appropriate SQL statement
But your hit about collections helped a lot, thanks.
Just for the records I'm using now:
Copy code
...
.orderBy(Performance.date)
.map { it[Production.name] }
.distinct()
.forEach {
println(it)
}2 Views